Date

@DAY

@DAY (date1)

Day portion of date1, e.g. "@DAY (1/28/2005)" returns 28

@DAYOFWEEK

@DAYOFWEEK (date1)

The day of week of date1, where 0=Sunday and 6=Saturday. E.g. "@DAYOFWEEK("1/10/2005") returns 1.

@DAYOFYEAR

@DAYOFYEAR (date1)

The day of year of date1, where 1 = January 1, 2 = January 2, and so forth. E.g. @DAYOFYEAR("2/1/2005") returns 32.

@DAYSINMONTH

@DAYSINMONTH (date1)

The number of days in the month specified within date1. E.g. @DAYSINMONTH ("2/1/2004") returns 29.

@MONTH

@MONTH (date1)

The month portion of the provided date string. E.g. @MONTH ("1/28/2005") returns 1.

@NOW

@NOW ()

The current date and time, e.g. "4/19/2005 3:50PM"

@TODATE

@TODATE (date1)

Converts input to date format. E.g:

• @TODATE("1/1/2005") will convert it to a real date. 1/1/2005 12:00:00 AM

• @TODATE(633673152000000000) will treat the integer as "ticks" and convert it to 1/12/2009 12:00:00 AM

• @TODATE("1/12/2009 12:30:00 AM") will convert it to a real date 1/12/2009 12:30:00 AM

• @TODATE(@GETVALUE([testD], &NULL)) will convert the value of the alias node of [testD] to a date time value

@TIME

@TIME (date1)

Returns either:

• The time portion of a date/time string (e.g. @TIME ("12/12/2009 08:31:04") returns 8:31:04 AM)

• The time portion of @NOW (e.g. @TIME(@NOW()) returns the current time in HH:MM:SS form), or

• The time string from a Task configured for DateTime input, (e.g. @TIME(@GETVALUE([TagName],&NULL)) returns the appropriate value).

@TODAY

@TODAY ()

The current date with a time of midnight, e.g. "4/19/2005 12:00AM"

@YEAR

@YEAR (date1)

The year portion of date1, e.g. @YEAR ("1/28/2005") returns 2005.