HoursFromDateTime

Returns a numerical value indicating the hours from the specified DateTime value. The hours are indicated in the 24-hour format, where 13 = 1 PM.

The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.

Usage

HoursFromDateTime(DateTime)

Where: DateTime - a double-precision decimal DateTime value

Example

HoursFromDateTime(39449.85000000) will return a value of 20, indicating 8 PM