Skip to content

Date Standardization Rule (date_standardization) โ€‹

Converts date formats from one pattern to another.

FieldDescriptionRequired
current_formatThe format of the existing date string (e.g., "%d-%m-%Y").โœ… Yes
new_formatThe desired output format (e.g., "%Y-%m-%d").โœ… Yes

Example: โ€‹

json
{
    "type": "date_standardization",
    "source_column": "transaction_date",
    "destination_column": "",
    "current_format": "%d-%m-%Y",
    "new_format": "%Y-%m-%d"
}

Behavior: Converts dates from "DD-MM-YYYY" format to "YYYY-MM-DD".