Solving Date Format Issues in Make.com: A User Guide

Hi there, fellow Make.com users! Today, I want to share a problem I recently encountered and how I managed to solve it. I hope this will help you if you ever find yourself in a similar situation.

The Problem

I was working on a scenario where I needed to create a Google Calendar event from a Google Form through Google Sheets. However, I kept running into an error: Missing value of required parameter ‘start’. The issue was with the date format. My Google Sheet was based on the Italian/European format (DD-MM-YYYY), which Make.com couldn't handle, leaving the date field blank.

The Solution

After several tests and with the help of the community, I found the solution. The command to put in the Start Date is {{parseDate(1.3; “DD/MM/YYYYTHH:mm”)}}. This command tells the module in what format it receives the date/time info.

Troubleshooting Tips

If you're still encountering issues, make sure your date is in the correct format. In my case, it was in the format dd/mm/yyyy. Also, remember to use the parse function like this: {{parseDate(1.Data di Arrivo; “MM/DD/YYYY”)}}.

Conclusion

Dealing with date formats can be tricky, but with the right commands and understanding of how Make.com handles date/time info, you can solve this problem. Remember, the community is always here to help. Keep testing and don't give up!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.