Variables Parameters

[Parameters]

Date and TIme

Format commands can be used in conjunction with the display of any date variables, such as ~date~, and ~time~.

  • Letters are case sensitive

  • Format commands can be combined

The ~date~ variable can also be added to the ~samp~ variable to display date and time information for a Sample. For example, you could use the variable ~samp,date,%c~ to display the create date and time of a Sample, formatted according to your computer's locale settings.

The default format for any date and time strings is the locale settings on your computer. However, you may use the date/time parameters in a way that allows you to show formats different that your default settings. For example, if the date was March 14, 2002, ~samp,date,% d-%b-%Y~ would resolve to "14-MAR-2002". If the time were 08:12:59, ~samp,date,% M past % H~ would resolve to "12 past 08".

%a

Abbreviated weekday name

%A

Full weekday name

%b

Abbreviated month name

%B

Full month name

%c

Date and time representation appropriate for locale

%d

Day of month as decimal number (01 – 31)

%H

Hour in 24-hour format (00 – 23)

%I

Hour in 12-hour format (01 – 12)

%j

Day of year as decimal number (001 – 366)

%m

Month as decimal number (01 – 12)

%M

Minute as decimal number (00 – 59)

%p

Current locale's A.M./P.M. indicator for 12-hour clock

%S

Second as decimal number (00 – 59)

%U

Week of year as decimal number, with Sunday as first day of week (00 – 53)

%w

Weekday as decimal number (0 – 6; Sunday is 0)

%W

Week of year as decimal number, with Monday as first day of week (00 – 53)

%x

Date representation for current locale

%X

Time representation for current locale

%y

Year without century, as decimal number (00 – 99)

%Y

Year with century, as decimal number

%z

Either the time-zone name or time zone abbreviation, depending on registry settings; no characters if time zone is unknown.

%Z

Percent

%%

Display the percent (%) sign.

Sample

act

Returns the label of the active sample in the query.

new

Returns the label of the sample with the newest creation date in the query.

newest

old

Returns the label of the sample with the oldest creation date in the query.

oldest

UCL & LCL

abs

Absolute limit value.

rel

Relative (to nominal) limit value.

eff

Effective date.

date

Limit update date.

first

First sample order label. This may return the effective dates of the first labeled feature.

last

Last sample order label. This may return the effective dates of the last labeled feature.