AddDays
Returns the UTC date and time for the day that is the number of days specified earlier than or later than the specified date and time.
Syntax
AddDays(numDays, baseDateTime)
Enabled for
Search/Dashboard | Yes |
Business Rules | Yes |
Quick Actions | Yes |
Workflow Objects | No |
Reports | No |
Parameters
numDays |
The number of intervals. If not specified, uses the default interval which is 0. Can be either a positive integer, to indicate days in the future, or a negative integer, to indicate days in the past. |
baseDateTime | (Optional) The base date for the function. If not specified, uses the default date which is the current date and time. |
Returns Value
DateTime value in UTC time.
If the system has to display the return value, it implicitly converts it to text, thereby allowing the display format to change depending on your culture code. See Available Languages and Cultures for a list of the culture codes used by HEAT. |
Example
$(AddDays(4))
If today is April 10, 2014, this function returns the DateTime value for April 14, 2014 at the same time of day.
$(AddDays(-4))
If today is April 10, 2014, this function returns the DateTime value for April 6, 2014 at the same time of day.
$(AddDays(10, mydate))
If the value of mydate is April 10, 2014, this function returns the DateTime value for April 20, 2014 at the same time of day.