Previous Topic

Next Topic

Book Contents

Book Index

Date String Formatting Examples

The following table shows common examples of Date and Time Strings that can be used in EnterpriseSCHEDULE variables and preprocessing as well as the resulting value assuming the current date is May 3rd 2016.

Date String

Resulting

Description

FORMAT="DD" (ADATE "TODAY")

3

The numeric value of the day without leading zeros or spaces

FORMAT="MMMMMMMMMM" (ADATE "TODAY")

May

The current month in string form

FORMAT="YYYY" (ADATE "TODAY")

2016

The current year in String form

FORMAT="MMMMMMMMMM/DD/YYYY"(ADATE"TODAY")

May/3/2016

Today's date separated by slashes with no leading zeros or spaces

FORMAT="JJJ" (ADATE "TODAY" + 1 DAY)

125

The Julian value of TODAY i.e. the xxx day of the year.

FORMAT="XXXXXXXXXXXXXXXXXXXX" (ADATE "NOW")

May 3 13:47:37 2016

The system based representation of the date.

FORMAT="WWWWWWWWWW" (ADATE "TODAY")

Monday

The day of the week

FORMAT="TTTTTTTTTTT" (ADATE "NOW")

13:47:37.43

Time of day using 24 hour clock in hours: minutes:seconds. milliseconds

FORMAT="UUUUUUUUU" (ADATE "NOW")

01:47:37.43

Time of day using 12 hour clock in hours: minutes:seconds. milliseconds

See Also

Appendix I - Formatting Date Strings in EnterpriseSCHEDULE

Date String Format Specifiers

Using Date Strings in Variables

Using Date Strings in Jobs

Using a formatted date string in Notifications