Make.com error

Fix the parseDate “not a valid date” error in Make.com

⚠️ Function 'parseDate' finished with error! is not a valid date or does not match the date format

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/2026 but the format says DD/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: mm means minutes, MM means month.

How to fix it

  1. Look at one real value and write the format token by token: MM month, DD day, YYYY year, HH:mm time.
  2. Make sure the separators in the format are the same as in the text.
  3. Wrap empty values: if(date_text; parseDate(date_text; MM/DD/YYYY); ), or filter empty rows out.
  4. 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.

📖 Make.com parseDate() reference →

Was this page helpful?

Practice the skill behind this fix

More Make.com errors