EndOfMinute

Returns the UTC date and time for the end of the local minute based on the local date and time of the current session.

Syntax

EndOfMinute(numMinutes, baseDateTime)

Enabled for

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

Parameters

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

Return 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.

In this release of HEAT, there is a known issue, where if the time zone offset between the current date and time and the DateTime value returned by the function is different, the return value is off by one hour. This happens when the current date is before daylight savings time and the DateTime value that is returned is after daylight savings time, or vice versa.

Example

$(EndOfMinute())

If today is April 10, 2014 at 1:43pm, it returns the very last tick of the minute 19 minutes from now, which is April 10, 2014 at 2:01:59pm.

If the current date and time is January 15, 2014 at 07:34 AM and your time zone is Pacific time (which is UTC-7 during daylight savings time but UTC-8 during standard time), this function returns the very last tick of the minute, which is January 15, 2014 at 07:34:59.9999 AM converted to UTC time, which is January 15, 2014 at 3:34:59.9999 PM.