get-hours-from-dateTime-difference

Calculates the difference between the hour part of two given date and time values and returns the difference.

Syntax

    get-hours-from-dateTime-difference(strDateTime1,strDateTime2)

Parameters

strDateTime1 is a string that represents one date and time to compare and is specified in the format yyyy-mm-ddThh:mm:ssZ.

strDateTime2 is a string that represents the other date and time to compare and is specified in the format yyyy-mm-ddThh:mm:ssZ.

For more information about date and time parameters, see Date and time parameters.

Returns

A number that holds the difference between the hour part of the given date and time values.

Example

The following expression returns a number of value 2:

get-hours-from-dateTime-difference('2000-10-30T11:12:20Z','1999-11-28T09:00:05Z')