When my system exports the Excel, it comes formatted as this 4/21/25 in the CSV and im getting an error cause of how the import is formatted. I’m trying to reformat it into YYYY-MM-DD, but can’t figure out how. I’m getting an invalid input date because of how it’s formatted in the CSV. I’ve tried format date and parse date. I need to get it in the new format to upload into another software
Hey there,
you need to use parseDate() first to turn it into a date variable. Then you can use formatDate() to reformat it.
This is the error I get. * Failed to map 'name': Function 'parseDate' finished with error! '04/21/25' is not a valid date or does not match the date format.
That’s the format I’m getting from the export. I’m trying to avoid having to open and reformat the date manually. When I do that it all works
Can you show a screenshot of the setup right now?
Welcome to the Make Community!
You are using the wrong format.
In your CSV it’s month date year.
The format you typed is year month date.
Not only that, you are using the wrong module. Did you mean to use a SET Variable module instead?
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
that makes sense, ill parse it and then convert it to YYYY-MM-DD?
Im new to this honestly so im trying to learn the best modules to use as I go. I need to get each cell converted to that date format from the other one and then put it back in the csv to upload to a CRM
yes, parseDate first then formatDate
Please do the Make Academy. Link is in the sidebar and on the main website.
If you require further assistance, my profile has a couple of links to resources that may help, or you can search my previous posts on my profile for answers to similar questions like these — parseDate and formatDate.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Hi @FSC_Team,
As @samliew suggested, you’ll need to first parse the date using the same format and then format it as required.
Here’s the syntax for that:
{{formatDate(parseDate(03/10/25; MM/DD/YY); YYYY-MM-DD)}}
Let me know if you’d like further assistance.
If this helps, please consider marking it as the solution 
Your errors are the {{}} and the comma , before the YYYY. You have to use this ; to separate parameters in functions
This is a fixed version
{{formatDate(parseDate(9.col7;"MM/DD/YY");"YYYY-MM-DD")}}
2 Likes