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

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")

 

2010

 

The current year in String form

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

 

May/3/2010

 

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"

 

May 3 13:47:37 2010

 

The system based representation of

(ADATE "NOW")

 

 

 

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