Date Functions
For HEAT Release 2014.3, we have added several date functions. Many of these new functions are similar to current functions but their names have been changed to better identify their purpose.
The following are the new date functions added in HEAT Release 2014.3:
Functions that add a specified interval:
- AddMinutes()
- AddHours()
- AddDays()
- AddWeeks()
- AddMonths()
- AddQuarters()
- AddYears()
Functions that return the beginning of a period:
- BeginningOfMinute()
- BeginningOfHour()
- BeginningOfDay()
- BeginningOfWeek()
- BeginningOfMonth()
- BeginningOfQuarter()
- BeginningOfYear()
Functions that return the end of a period:
- EndOfMinute()
- EndOfHour()
- EndOfDay()
- EndOfWeek()
- EndOfMonth()
- EndOfQuarter()
- EndOfYear()
Starting in HEAT Release 2015.1, the following date functions will be deprecated. However, their functionality has not been removed, rather, it has been moved to a different function:
- CurrentDateTime()
- DateAdd()
- DateDiff()
- EndOfNextYear()
- EndOfThisMonth()
- EndOfThisYear()
- Last3Months()
- Last365Days()
- Last90Days()
- LastDays()
- LastSevenDays()
- LastThirtyDays()
- LastWeeks()
- LastYears()
- NextDays()
- StartOfNextYear()
- StartOfPreviousMonth()
- StartOfThisMonth()
- StartOfThisYear()
- Today()
- Tomorrow()
- Yesterday()