Make.com LabAdvanced
Parse a Custom Date Format with parseDate() in Make.com
A Google Sheet stores dates as text like 25/12/2026. Make reads it wrong unless you tell it the format.
Live Execution Simulator
Idle
📥
Incoming Data
⚙️
Make.com Node
🎯
Next Step
> Ready. Type your expression below and click "Check Answer" to run the node.
Incoming Payload / Data:
{
"date_text": "25/12/2026"
}
Press Enter or click Check Answer. +30 XP
✅ Solution & explanation
parseDate(date_text; DD/MM/YYYY)
Output: 2026-12-25 (date)
parseDate(text; format) converts text into a date using the tokens you provide: DD = day, MM = month, YYYY = year. Without it, 25/12 can be misread or rejected.💡 Pro tip: Add a timezone as the 3rd argument when the text has no time: parseDate(date_text; DD/MM/YYYY; Asia/Dubai).
Also accepted: parseDate(date_text; "DD/MM/YYYY")