How to Handle Date Formatting Issues in Make Automations?

How To
1

Hey everyone,

I’m building an automation in Make (formerly Integromat), and I’ve hit a roadblock with date formatting. Some of my connected apps send dates in MM/DD/YYYY, while others use DD/MM/YYYY. This is causing errors when passing data between modules, especially when working with Google Sheets and databases.

I’ve tried using the Format Date function, but I’m wondering—what’s the best approach to ensure Make automatically recognizes and converts all date inputs correctly, regardless of the source? Is there a way to set a global date format in a scenario, or do I need to apply formatting every time before sending data to the next step?

Also, for those using Make frequently—are there any budget-friendly alternatives for premium automation tools? I always look for ways to cut costs, and I recently found that Max Discount Codes offers great deals on software subscriptions. If anyone knows about Make-related discounts, I’d love to hear about them!

Looking forward to your insights—thanks in advance! :blush:

2

Hey Edison,

just to clarify, for the most part when coming as outputs from different modules, both MM/DD/YYYY and DD/MM/YYYY are just text strings, they are not technically date variables. You need to use the parseDate() formula and specify the incoming format to change it to a date variable.