Master Date Formatting in Data Mapping with Make.com

Have you ever faced issues with date formatting while working on data mapping between Zohoform and Smartsuit? Well, you're not alone. This is a common problem that many users encounter. But don't worry, we've got a solution for you.

The Problem

The main issue arises when you try to format your data, but the system doesn't recognize it. For instance, if you enter a date as 01-Jan-2019 (DD-MMM-YYYY), it's not a valid date format that Make recognizes to detect/coerce as a date, so the variable continues to be typed as a string.

The Solution

To solve this problem, you need to use the parseDate() function to parse the string into a date variable type using the Date Format Tokens. Once you've parsed the string into a date variable, you can then use the formatDate() function to display it in the desired format.

Troubleshooting Tips

If you're still facing issues, make sure to check the following:

• Ensure that you're using the correct date format tokens.
• Make sure that you're not trying to parseDate a second time, because it's already a date type.
• If the output data is changing automatically, use formatDate() when mapping variables in another module.

Conclusion

Dealing with date formatting can be tricky, but with the right approach and understanding of the functions, you can easily overcome this challenge. Remember to use parseDate() to convert the string into a date variable and then use formatDate() to display it in the desired format. Happy data mapping!

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.