Extracted Data
1. Overview
Syntax | DATETONUMBER(Date) | Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date. |
Parameter | Date | In FineBI V5.1.12 and later versions, the Date parameter can only be of the text or date type, which follows the logic of the serial numbers in the 1900 date system. For example, the serial number 35796 represents January 1,1998. |
The function supports only one date or text parameter and will be illegal if more than one date or text parameters are set.
3. Example
| Formula | Result | Note |
|---|---|---|
DATETONUMBER("2008-08-08") | 1,218,124,800,000 | |
DATETONUMBER(35796) | 883,612,800,000 |
Real-Time Data
1. Overview
Syntax | DATETONUMBER(Date) | Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date. |
Parameter | Date | The Date parameter can only be of the text or date type. |
2. Notes
The function supports only one date or text parameter and will be illegal if more than one date or text parameters are set.
3. Example
| Formula | Result | Note |
|---|---|---|
DATETONUMBER("2008-08-08") | 1,218,124,800,000 |
