date_value
Converts a text string to a date value.
Syntax
date_value(<val>, <layout>)
| Parameter | Type | Description |
|---|---|---|
| val | Text | The text string containing a date value to convert. |
| layout | Text | The date format pattern (optional). If not provided, common date formats are automatically detected. |
Return values
Date
Usage
Converts the text string '2024-01-15' to a date value.
date_value("2024-01-15")