DATEVALUE ^v2.6.131 ​

Converts a text string representing a date to a date value.

DATEVALUE(date_text)

DATEVALUE(date_text)

Parameters ​

• date_text - The text string representing a date to convert to a date value in yyyy-mm-dd format.

Examples ​

DATEVALUE("2023-04-17")

DATEVALUE("2023-04-17")

Result: 45033

Note: Converts the text string '2023-04-17' into a date value.