DateTime2ELTime
Revision as of 10:59, 19 January 2012 by 194.84.116.138 (talk) (Created page with "Returns a numerical value indicating the time from the specified DateTime value. The time is indicated in the 24-hour HHmm format, where 1300 = 1:00 PM. The integer portion ...")
Returns a numerical value indicating the time from the specified DateTime value. The time is indicated in the 24-hour HHmm format, where 1300 = 1:00 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
Where: DateTime - a double-precision decimal DateTime value
Example
DateTime2ELTime(39449.65625000)
will return a value of 1545, indicating 3:45 PM