DATETONUMBER

Last update： 2022-04-04

1. Extracted data

1）Overview

Syntax	DATETONUMBER(date)	Returns the number of milliseconds passed since 00:00:00GMT on January 1, 1970.
Parameter	date	date can be a text, a date, or a number. It is processed logically in the year 1900. For example, 35796 is 1998-01-01.

2）Precaution

Supports a date or text type parameter, if more than one parameter, that is invalid.

3）Example

Formula	Result	Remark
DATETONUMBER("2008-08-08")	1,218,124,800,000
DATETONUMBER(35796)	883,612,800,000

2. Real-time data

1）Overview

Syntax	DATETONUMBER(date)	Returns the number of milliseconds passed since 00:00:00GMT on January 1, 1970.
Parameter	date	data supports only text and data types.

2）Precaution

Supports a date or text type parameter, if more than one parameter, that is invalid.

3）Example

Formula	Result	Remark
DATETONUMBER("2008-08-08")	1,218,124,800,000

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy