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

[Ben_Duwel]

Hi there,

I have a form that outputs dates in the format “DD/MM/YYYY”, using the format date function I have tried to switch this to “YYYY-MM-DD” which works fine, except when the Day of the month is lower than 12. in this case it flips the month and the day.

Anyone know a fix?

[samliew]

Welcome to the Make community!

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[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.