| [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. |