DATEVALUE

Converts a date in text format to a date value that AnyDB recognizes.

Syntax

DATEVALUE(date_text)

Arguments

• date_text: Text representing a date.

Example

DATEVALUE("2025-03-02") → Returns the date value for March 2, 2025
DATEVALUE(A1) → Converts the text date in cell A1 to a date value