# Date formatting acting weird **URL:** \ **Category:** Questions\ **Tags:** date-time-functions\ **Created:** [October 14, 2024, 1:09pm UTC](https://community.make.com/t/date-formatting-acting-weird/57821 "2024-10-14T13:09:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jan\_Gess](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jan_gess/32/33797_2.png) [@Jan\_Gess](https://community.make.com/u/Jan_Gess)\ **Post date:** [October 14, 2024, 1:09pm UTC](https://community.make.com/t/date-formatting-acting-weird/57821/1 "2024-10-14T13:09:03Z")
I’m retrieving a date from a Google Sheets. I want to add some days and subtract days from the date I get from Google Sheets. _Sometimes_ this works as expected, but sometimes it swaps the month and day. In the example screenshots, I get 2 bundles with dates from Google Sheets: - Bundle 1: 06/11/2024 - Bundle 2: 20/11/2024 In the next (set variables) module, I apply the addition and subtraction. Here the weird thing happens: - Bundle 1: 06/11/2024 is interpreted at 11 June 2024 (incorrect) - Bundle 2: 20/11/2024 is interpreted as 20 November (correct) All other things are equal, so I don’t see how I can fix this. Can anyone help? [blueprint.json](https://community.make.com/uploads/short-url/vtVL9A4u3ux6APTCDX2cXmiCcER.json) (408.4 KB) ![Screenshot 2024-10-14 at 2.57.48 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/8/386a57c8394df3006b2f260c7c0f3a7f28cedb98.png) ![Screenshot 2024-10-14 at 2.57.32 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/c/ec5590d35e26bc3484ac8c94e5d75ccad890f916.jpeg) ![Screenshot 2024-10-14 at 2.55.21 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/4/e43abd145e25918b7f9d8834958cb61e06d83b19.png) ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [October 14, 2024, 1:18pm UTC](https://community.make.com/t/date-formatting-acting-weird/57821/2 "2024-10-14T13:18:05Z")
Hi @Jan_Gess, Can you check and confirm that neither your Google Sheets column, your Make Profile (so your user) and your Make Organization are set in the wrong timezone? You can set a custom date and time format for your column in GS and normally the timezone you set for your Make user is the timezone that is shown in the UI. If you trust that is OK, you can try to give the timezone as extra argument in your `formatDate()` function: [https://www.make.com/en/help/functions/date---time-functions#formatdate--date--format---timezone--](https://www.make.com/en/help/functions/date---time-functions#formatdate--date--format---timezone--) Cheers, Henk ---
**Author:** ![Jan\_Gess](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jan_gess/32/33797_2.png) [@Jan\_Gess](https://community.make.com/u/Jan_Gess)\ **Post date:** [October 17, 2024, 5:03pm UTC](https://community.make.com/t/date-formatting-acting-weird/57821/3 "2024-10-17T17:03:53Z")
No, the time zones are ok. But I managed to solve it with a Parsedate followed with a Formatdate starting with the year. Still not sure what went wrong, but it works now 👍 ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [October 18, 2024, 3:47am UTC](https://community.make.com/t/date-formatting-acting-weird/57821/4 "2024-10-18T03:47:11Z")
Hi @Jan_Gess You have to do like this: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/7/e7755abb228566828c8c7f0a1d66f070166be528.png) output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/b/3bd7f630f72aff2457b4bb4ddf37d7e950cb2972.png) If you wat the output in MM/DD/YYYY, Do as follows, ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/e/0e49849c1c97a545d28669b88c6077c6c5474665.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/0/a08dc1c3b30133c70f5b8f38dec9c0479b9d255f.png) **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**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:** [October 18, 2024, 5:10am UTC](https://community.make.com/t/date-formatting-acting-weird/57821/5 "2024-10-18T05:10:58Z")
Hello @Jan_Gess, As @Msquare_Automation suggests, always use [parseDate](https://www.make.com/en/help/functions/date---time-functions#parsedate--text--format---timezone--) and make sure you use the right set of [formatted tokens](https://www.make.com/en/help/functions/tokens-for-date-time-parsing)(character) based on current format. It will always works fine. There are no timezone issues. I strongly recommend you also to check the official Make’s Academy course. It’s worth to check. > [@purple\_circle Make Academy: Course Overview](https://community.make.com/t/make-academy-course-overview/29699): > > Hey Makers wavemortar_board Kickstart your learning journey with our [Make Academy](https://academy.make.com/)! Today we’d like to share a summary of all the available courses. Enroll now, and learn the essential skills to learn automation at your own pace! mortar_board > > > **Click for basic information about the Make Academy** > > > > Every certification contains various courses and units. books Each certification aims to upskill Makers with some of the fundamentals of Make. brick Make Foundation sets the groundwor… ---
**Author:** ![Jan\_Gess](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jan_gess/32/33797_2.png) [@Jan\_Gess](https://community.make.com/u/Jan_Gess)\ **Post date:** [October 18, 2024, 7:10am UTC](https://community.make.com/t/date-formatting-acting-weird/57821/6 "2024-10-18T07:10:55Z")
Thanks everyone. It works now, but just out of curiosity: If you look at my original screenshots, why is it that from the same Google Sheets, Make processes 2 lines differently? One operation Make interprets the date field as DD/MM/YYYY, the other operation as MM/DD/YYYY. ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [October 25, 2024, 4:35am UTC](https://community.make.com/t/date-formatting-acting-weird/57821/7 "2024-10-25T04:35:35Z")
hi @Jan_Gess If you pass a date like 06/11/2024 without specifying a format in Make, it will interpret the date in MM/DD/YYYY format by default. So, when you input 06/11, it reads it as June 11. However, if you enter something like 20/11, it tries to interpret it as MM/DD, but since there’s no 20th month, Make will automatically adjust, taking 20 as the day and 11 as the month. This is how the system handles date interpretation in the background. Hope that clears things up! Thank you. Glad to know that your issue is resolved now. We would really appreciate if you mark the answer as solution if it helped you. This will keep the community healthy and organized. If you need further assistance please feel free to reach out. **Best regards,** **Msquare Automation** _platinum Partner of Make_ @Msquare_Automation ---
**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 23, 2025, 5:40am UTC](https://community.make.com/t/date-formatting-acting-weird/57821/8 "2025-01-23T05:40:25Z")