Trip codes are case sensitive. When specifying trip codes, you should use the case indicated in the table below.
The format for a date trip sequence is %D<format>%, where <format> contains one or more of the trip codes listed below. The resulting date is affected by the Trip Sequence Time field on the Crystal Report Form (see Specify the Trip Sequence Time).
ClearSCADA supports these trip codes for date strings within exported reports:
| Trip Sequence | Description | Example |
|---|---|---|
|
d |
The day of the month as a digit. No leading zeros are included for single-digit days. |
3 |
|
dd |
The day of the month as a digit.Leading zeros are included for single-digit days. |
03 |
|
ddd |
The day of the week, abbreviated to three letters. |
Tue |
|
dddd |
The full name for the day of the week. |
Tuesday |
|
M |
The month as a digit.Leading zeros are excluded for single-digit months. |
4 |
|
MM |
The month as a digit.Leading zeros are included for single-digit months. |
04 |
|
MMM |
The month, abbreviated to three letters. |
Aug |
|
MMMM |
The full name for the month. |
August |
|
y |
The last two digits of the year. Leading zeros are not included for years below 10. |
5 |
|
yy |
The last two digits of the year. Leading zeros are included for years below 10. |
05 |
|
yyyy |
The year, presented as four digits. |
2005 |
|
gg |
The era. |
AD |
Example:
The code%Dd MMM yy%
displays a date in the form
2 May 05
(to display the date of the month as two digits, you would use dd, rather than d)
The code%Dddd, dd MMMM%
displays a date in the form
Fri, 04 March