Solving Date Parsing Issues on Make.com: A Guide to Correctly Pass Dates to Google Sheets
Hey there, Make.com users! Today, we're going to tackle a problem that some of you might have encountered - parsed dates passing to Google Sheets as timestamps. It's a bit of an odd behavior, but don't worry, we've got a solution for you!
The Problem
So, you've been using Make.com and everything's been going smoothly. But then, you notice something strange. You've parsed the date correctly on your Update Rows module, but Google Sheets is still getting the unparsed Unix timestamp. You've used the syntax: {{parseDate(35.end_time; "YYYY-MM-DD HH:mm")}} and everything seems to be in order. So, what could be causing this? Is it something on Google’s end? It's a bit of a head-scratcher, isn't it?
The Solution
Well, after some digging, we've found the solution. And it's simpler than you might think. Instead of using parseDate(), you should use formatDate(). That's it! This simple change should solve the problem and your dates should now pass to Google Sheets correctly.
Troubleshooting Tips
If you're still encountering issues, here are a few troubleshooting tips:
- Double-check your syntax. A small typo can cause big problems.
- Make sure you're using the correct function. In this case, it's
formatDate(), notparseDate(). - Try refreshing your page or restarting your device. Sometimes, a simple reset can fix the issue.
Conclusion
So, there you have it! A simple solution to a puzzling problem. Remember, when you're using Make.com and you encounter an issue, don't panic. There's usually a simple solution. And don't forget to share your insights with the community. We're all here to help each other out. Keep up the great work, Make.com users!
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.
