Fix the parseDate “not a valid date” error in Make.com
What this error means
parseDate(text; format) reads the text using the tokens you give it. If the text doesn't follow that pattern — or is empty — Make can't build a date and the function fails.
Common causes
- Day and month are swapped: the text is
12/25/2026but the format saysDD/MM/YYYY. - The separators differ (
-vs/) or the text has a time you didn't include in the format. - The cell is empty for some rows.
- Lowercase vs uppercase tokens:
mmmeans minutes,MMmeans month.
How to fix it
- Look at one real value and write the format token by token:
MMmonth,DDday,YYYYyear,HH:mmtime. - Make sure the separators in the format are the same as in the text.
- Wrap empty values:
if(date_text; parseDate(date_text; MM/DD/YYYY); ), or filter empty rows out. - Add a timezone as the third argument when the text has no time zone.
❌ Breaks
parseDate(date_text; DD/MM/YYYY) # date_text = 12/25/2026 → error
✅ Works
parseDate(date_text; MM/DD/YYYY)
💡 Pro tip: When a source mixes formats, normalize it once with a Set variable module and parse the clean value everywhere else.
🧪 Fix it yourself
A US system exports dates as month/day/year. parseDate fails because the format is written day-first.
{
"date_text": "12/25/2026"
}
Press Enter or click Check Answer.
✅ Solution
Output: 2026-12-25 (date)