Function Name |
Description |
Syntax |
Arguments |
Example |
AddDays |
Adds the specified number of days to a date. You may want to use this function to define a calculation data item. |
AddDays(date,numDays) |
date: A date. numDays: Number of days to add. |
AddDays("5/1/2000", 10) |
AddHours |
Adds the specified number of hours to a date. You may want to use this function to define a calculation data item. |
AddHours(dateTime,numHours) |
dateTime: A date with a time. numHours: Number of hours to add. |
AddHours("01/01/2011" "01:15", 3) |
AddMinutes |
Adds the specified number of minutes to a date. You may want to use this function to define a calculation data item. |
AddMinutes(dateTime,numMinutes) |
dateTime: A date with a time. numMinutes: Number of minutes to add. |
AddMinutes("01/01/2011" "01:15", 45) |
AddMonths |
Adds the specified number of months to a date. You may want to use this function to define a calculation data item. |
AddMonths(date,numMonths) |
date: A date numMonths: Number of months to add. |
AddMonths("01/01/2011", 9) |
BuildDate |
Returns a date from the specified year, month, and day. Note: This function does not require a month and day, but if you do not insert a value for these arguments, they will default to 1. |
BuildDate(Numeric year, Numeric month, Numeric day) |
Numeric year: An integer for a year. Numeric month: An integer for a month. Numeric day: An integer for a day. |
BuildDate(2010, 12, 3) |
Now |
Returns the current Date and Time in the local time zone, as of the start rule processing. |
Now() |
Current date and time in the local time zone are set by default |
Now() |