Function reference
Convert a DateTime or Date to the equivalent “Microsoft” number of days after the base date 1899-12-30. This number is used by Excel and MS ODBC drivers.
Use his function when querying Date and DateTime columns in TXT/CSV files using SQL.

DateTimeToNumber( string )

Argument Description
string The DateTime or Date as literal string to convert into the number of days after the base date 1899-12-30

Data type: Decimal
Returns a number of type Decimal

Example 1
This expression returns 43197.47802083
DateTimeToNumber( ’2018-04-07 11:28:21’)

Example 2
This expression returns 43197
DateTimeToNumber( ’2018-04-07’)

Last modified: 23 May 2021