The READ_DATE function allows you to read a date from formatted text and convert it into a date format that can be used by your system. This is particularly useful when working with raw data where dates are stored as unstructured text or in a specific format that the system does not recognize by default.

➡️ Display name:

➡️ Syntax :

➡️ Example: 

➡️ The result 25-12-2024 in output format becomes a usable date

In this example, the date in day-month-year format ("25-12-2024") is text, and you need to format it into a standard date.

"classic": Specifies that the "DD-MM-YYYY" parameter is one of the recognized formats listed below.

➡️ To define the function with both date and time mentioned "extended" instead of "classic"