Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

Description

Normalizes a date string to ISO 8601 format (YYYY-MM-DD or YYYY-MM-DDThh:mm:ss). Use it to standardize date values from mixed sources before storing, sorting, or joining on date.

Syntax

NormalizeDate(string_expression)

Examples

NormalizeDate('January 5, 2024') returns '2024-01-05'. NormalizeDate('05/01/2024') returns '2024-01-05'. NormalizeDate('2024-1-5') returns '2024-01-05'.

Return value datatype

String

Impact of null value

If input is null, returns null. If the input cannot be parsed as a valid date, returns null.
Last modified on May 26, 2026