Reference > Expressions > Built-in Functions > Date Functions > AddHours

AddHours

Returns the UTC date and time for the hour that is the number of hours specified earlier than or later than the specified date and time.

Syntax

AddHours(numHours, baseDateTime)

Enabled for

Search/Dashboard Yes
Business Rules Yes
Quick Actions Yes
Workflow Objects No
Reports No

Parameters

numHours

The number of intervals. If not specified, uses the default interval which is 0. Can be either a positive integer, to indicate hours in the future, or a negative integer, to indicate hours in the past.
baseDateTime (Optional) The base time for the function. If not specified, uses the default time 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

$(AddHours(4))

If today is April 10, 2014 at 07:30 AM, this function returns the DateTime value for April 10, 2014 at 11:30 AM.

 

$(AddHours(-4))

If today is April 10, 2014 at 07:30 AM, this function returns the DateTime value for April 10, 2014 at 03:30 AM.

 

$(AddHours(10, mydate))

If the value of mydate is April 10, 2014 at 07:30 AM, this function returns the DateTime value for April 10, 2014 at 5:30 PM.