Format-Date flips month and day when the day value is lower than 12

[dilipborad]

Hello @Ben_Duwel,
You can check make date time functions. Specifically check parsedate and formatdate

Also check my other posts regarding same type of issues. Read original post and answers.

Error parsing date

Hello Ken, Sorry, I’ve made a mistake in the written formula. Just updated it on the previous post and also wrote it down formula here. {{formatDate(parseDate("31 Mar 24"; "DD MMM YY"); "YYYY-MM-DD")}}

Can't Filer on date and time

Hello @Stanislas_Berteloot The first thing is that you need to know how the functions work or write (syntax) in Make. https://www.make.com/en/help/functions/using-functions The Make Function has a specific syntax, But in your second attached image, you’ve just written it down as like text. While using the function or previous steps data, I strongly recommend using that data selection panel. This is just an example of how to write that same thing using Make’s function syntax. {{formatDate(n…

Date/Time to Airtable

Fighting this two days and counting My Airtable “Create a Record” module is not passing the correct date/time from a webhook to Airtable. I’m getting {October 23, 2024 4:01 PM} from my webhook, but {October 22, 2024 7:00 PM} is getting passed to Airtable. [webhook to airtable1] [format]

If that’s not enough then please come back with more specific details of your issue as @samliew post.