Date and time rules functions

Rules functions that work with dates and time.

DATE
DATE returns the date string in yy-mm-dd or yyyy-mm-dd format for a given serial number.
DATES
DATES returns a date string, in the form 'yy-mm-dd' or 'yyyy-mm-dd', corresponding to a given year, month, and day.
DAY
DAY returns a numeric value for the day in a given date string.
DAYNO
DAYNO returns the serial date number corresponding to a given date string.
MONTH
MONTH returns a numeric value for the month in a given date string.
NOW
NOW returns the current date/time value in serial number format.
TIME
TIME returns a string, in HH:MM format, representing the system time on the Planning Analytics database.
TIMST
TIMST returns a formatted date/time string.
TIMVL
TIMVL returns the numeric value of a component (year, month, etc.) of a date/time value.
TODAY
TODAY returns the current date in yy-mm-dd format.
YEAR
YEAR returns a numeric value for the year in a given date string.

Parent topic: Rules functions