# Format-Date flips month and day when the day value is lower than 12 **URL:** \ **Category:** Questions\ **Tags:** format-date\ **Created:** [November 1, 2024, 7:04am UTC](https://community.make.com/t/format-date-flips-month-and-day-when-the-day-value-is-lower-than-12/59402 "2024-11-01T07:04:51Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Ben\_Duwel](https://avatars.discourse-cdn.com/v4/letter/b/b2d939/32.png) [@Ben\_Duwel](https://community.make.com/u/Ben_Duwel)\ **Post date:** [November 1, 2024, 7:04am UTC](https://community.make.com/t/format-date-flips-month-and-day-when-the-day-value-is-lower-than-12/59402/1 "2024-11-01T07:04:51Z")
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? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [November 1, 2024, 11:43am UTC](https://community.make.com/t/format-date-flips-month-and-day-when-the-day-value-is-lower-than-12/59402/2 "2024-11-01T11:43:11Z")
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: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/20b53cdf28d223e85fc9654c350eadebd37f5d3c.png) # 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. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/2ff55ee04419049c127f183db2b3eebfbbbbfc64.png) # 3. Output Bundles of Modules Please provide the **output** bundles of the modules by running the scenario (or get from the [scenario History tab](https://www.make.com/en/help/scenarios/scenario-execution-history)), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png) ### 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** - **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! ---
**Author:** ![dilipborad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/dilipborad/32/53211_2.png) [@dilipborad](https://community.make.com/u/dilipborad)\ **Post date:** [November 1, 2024, 7:25pm UTC](https://community.make.com/t/format-date-flips-month-and-day-when-the-day-value-is-lower-than-12/59402/3 "2024-11-01T19:25:32Z")
Hello @Ben_Duwel, You can check make date time functions. Specifically check [parsedate](https://www.make.com/en/help/functions/date---time-functions#parsedate--text--format---timezone--) and [formatdate](https://www.make.com/en/help/functions/date---time-functions#formatdate--date--format---timezone--) Also check my other posts regarding same type of issues. Read original post and answers. > [@Error parsing date](https://community.make.com/t/error-parsing-date/58068/5): > > 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")}} point_up_2 > [@Can't Filer on date and time](https://community.make.com/t/cant-filer-on-date-and-time/57769/2): > > 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](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](https://community.make.com/t/date-time-to-airtable/58773): > > Fighting this two days and counting laughing 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. If that’s not enough then please come back with more specific details of your issue as @samliew post. 👍 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [January 30, 2025, 7:30pm UTC](https://community.make.com/t/format-date-flips-month-and-day-when-the-day-value-is-lower-than-12/59402/4 "2025-01-30T19:30:35Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.