DayFromDateTime (Reserved Word)

image\trumpet2.gif Disclaimer

Returns the numeric day of the month for the specified DateTime value.

DayFromDateTime(dDateTime);

Where dDateTime is a double-precision decimal expression that represents the combination of a Julian date value (using December 30, 1899 as day 0) and a fraction that represents the time (using midnight as time 0).

Remarks

If a specific date is entered for the numeric expression, it must be a valid Julian date between December 30, 1899 and February 28, 2150, expressed in DateTime format.

Examples

Value1 = DateFromDateTime(45161.61200);  returns a day value of 23 for the specified DateTime of 45161.61200 (8/23/2023 2:41:17 PM).

See Also

DateTime (class)