Format Custom Dates in n8n Using Date & Time Node

Convert Custom Date Strings in n8n (Manually) with the Date & Time Node

This n8n workflow lets you take a date string like 14/02/2020 and parse it into a normalized date using the Date & Time node—so you can turn messy, source-specific date formats into consistent, automation-ready values.

What this workflow does

Built for n8n users who need predictable date parsing, the workflow follows a simple, manual process:

• Manual trigger: Start the workflow by manually executing it in n8n.
• Parse the input date: Provide a date value and configure the Date & Time node to match your input format.
• Use the correct format: The example input date 14/02/2020 is parsed using the DD/MM/YYYY format.
• Get normalized output: The workflow produces a parsed, normalized date value based on the format you specify.

Use cases

• Clean up imported data: When dates arrive from CSVs or external sources in DD/MM/YYYY (or another custom format).
• Validate parsing during development: Test whether your configured date format matches your source data before wiring it into larger automations.
• Standardize SaaS workflows: Ensure consistent date handling for downstream steps in your n8n automations.

Technical details

• n8n Manual Trigger to run the workflow on demand.
• Date & Time node to parse the input date string.

Setup tip: Set both the input date value and the expected input format in the Date & Time node so it matches your source data. Run the workflow manually to confirm the parsed output is correct.