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".