Date and Time Formats Variable
You must specify a date and time format for the Automation Engine and object properties within the name of the variables that return a date or a time. The following table lists the variables that are affected and informs you about the formats that are supported.
Certain characters that occur in some formats must not be used in variable names. Therefore, you must specify the formats that include such characters in the variable name as shown below:
- Time format: Within a variable name, you must specify time formats that include a colon character (:) with an underscore _").
- Date format: You can use a hyphen (-), dot (.) or slash (/) character in date formats. In this case, you must also use an underscore instead of these characters in the variable name. Additionally, you must specify the character that is included in the format at the end of the format: For a point, you append the string _p, for a slash, you append _s and for a dash, you append _d.
For example: &$TIME_HH_MM_SS# returns the time in the format HH:MM:SS
Examples
- &$PHYS_DATE_YY_MM_DD_p# supplies the date in the format YY.MM.DD
- &$PHYS_DATE_YY_MM_DD_d# supplies the date in the format YY-MM-DD
- &$PHYS_DATE_MM_DD_YY_s# supplies the date in the format MM/DD/YY.
Keys
-
Time
Variables: &$PHYS_TIME_format# , &$TIME_format#
Format used in variable Format displayed HHMMSS HHMMSS HH_MM_SS HH:MM:SS HHMM HHMM HH_MM HH:MM HH HH MM MM -
Date
Variables: &$DATE_format#, &$LDATE_format#, &$PHYS_DATE_format#
Format used in variable Format displayed YY YY YYYY YYYY YYMMDD YYMMDD YY_MM_DD_p YY.MM.DD YY_MM_DD_d YY-MM-DD YYYYMMDD YYYYMMDD YYYY_MM_DD_p YYYY.MM.DD YYYY_MM_DD_d YYYY-MM-DD DD DD DDMMYY DDMMYY DDMMYYYY DDMMYYYY DD_MM_YY_p DD.MM.YY DD_MM_YY_d DD-MM-YY DD_MM_YYYY_p DD.MM.YYYY DD_MM_YYYY_d DD-MM-YYYY LLL LLL MM MM MMDDYY MMDDYY MMDDYYYY MMDDYYYY MM_DD_YY_s MM/DD/YY MM_DD_YYYY_s MM/DD/YYYY DD_MON_YYYY_d DD-MON-YYYY DD_MON_RR_d DD-MON-RR MM_DD_YYYY_d MM-DD-YYYY MMDDRR MMDDRR DDMMRR DDMMRR MM_DD_RR_d MM-DD-RR MM_DD_RR_s MM/DD/RR TT TT WW WW
Special formats that you must specify as shown in the variable name:
- WEEK_NR: The number of the week to which the date belongs to is returned (43, for example).
- WEEKDAY_NR: The number of the week day (7, for example)
- YEAR_9999: The year is shown as a four-digit number (2012, for example)
- YEAR_99: The year is shown in a two-digit number (12, for example)
- WEEKDAY_XX: The variable returns the two-digit abbreviation of the weekday that belongs to the date.
See also: