(Sorry for my english)
Hi I get an issue with my scenario because I have some filters with birthdate but make can’t recognize the french format… for exemple i need to filter underage people and not underage people but the date is in this format DD/MM/YYYY but in the filter make use it in this format : MM/DD/YYYY so the filter isn’t working. So to resolve it two solutions : how to make my filter read the date in french format or change my date format in this format MM/DD/YYYY for the filter
Thanks a lot
Hello @victor.lucienbrun
You can change your date format using this formula formatDate(date;MM/DD/YYYY).
If you want to learn and read more about Make.com date and time functions you can visit this link Date and time functions (make.com)
Don’t hesitate to contact us if you require further assistance.
//VLAD
2 Likes
Thank for your reply Vlad but this doesn’t work ! Example :
Bonjour @victor.lucienbrun,
When you hover over the mapping for the date with your cursor, do you see “text” as the data type?
If it’s a text, you’ll need to use parseDate() first to transform it from text → date. And then use the formatDate() to change it to the desired date output. Like this:
This will take my text input date (12/20/2001) to output 20/12/2001
Hope this helps!
2 Likes
Thanks Nola,
It’s working but when the day is superior to 12 tools ended with an error :
@victor.lucienbrun maybe your date is a string and you have to use parseDate formula to transform string fromat in Date format.
2 Likes
This is the solution !
Thanks a lot
2 Likes
I just saw that Nola already gave you the same answer.
