# I want to transform a date in this format : DD/MM/YYY to this format : MM/DD/YYYY **URL:** \ **Category:** Questions\ **Tags:** format-date\ **Created:** [March 18, 2024, 12:04pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834 "2024-03-18T12:04:02Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![victor.lucienbrun](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@victor.lucienbrun](https://community.make.com/u/victor.lucienbrun)\ **Post date:** [March 18, 2024, 12:04pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/1 "2024-03-18T12:04:02Z")
(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 ![Capture d'écran 2024-03-18 130045](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/6/e6b0e5471cbc7887358a2bdd265e99d7b7cd8282.png) ![Capture d'écran 2024-03-18 130017](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/2/8269bfc0d5897bab4f5272d19b39ce6a21750f5a.png) Thanks a lot ---
**Author:** ![Wemakefuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/wemakefuture/32/103_2.png) [@Wemakefuture](https://community.make.com/u/Wemakefuture)\ **Post date:** [March 18, 2024, 1:28pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/3 "2024-03-18T13:28:44Z")
Hello @victor.lucienbrun You can change your date format using this formula formatDate(date;MM/DD/YYYY). ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/6/064d751e757842953a35a12230eead78a82c007e.png) If you want to learn and read more about [Make.com](http://Make.com) date and time functions you can visit this link [Date and time functions (make.com)](https://www.make.com/en/help/functions/date---time-functions) Don’t hesitate to contact us if you require further assistance. //VLAD ---
**Author:** ![victor.lucienbrun](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@victor.lucienbrun](https://community.make.com/u/victor.lucienbrun)\ **Post date:** [March 18, 2024, 1:35pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/4 "2024-03-18T13:35:09Z")
Thank for your reply Vlad but this doesn’t work ! Example : ![Capture d'écran 2024-03-18 143444](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/b/fb27d24dcb864f092e2789f53c28b7d5898d8d79.png) ![Capture d'écran 2024-03-18 143431](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/c/dcd449fd0c76b9a7df323e06df7307c1df41dd2b.png) ![Capture d'écran 2024-03-18 143412](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/807dd5f52b5dc917341f317941f1f89efe7a0daa.png) ---
**Author:** ![NolaDigital](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/noladigital/32/226_2.png) [@NolaDigital](https://community.make.com/u/NolaDigital)\ **Post date:** [March 18, 2024, 1:46pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/5 "2024-03-18T13:46:52Z")
Bonjour @victor.lucienbrun, When you hover over the mapping for the date with your cursor, do you see “text” as the data type? ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/e/8e4fe87342684729c801a45db157974a83cf6dae.png) 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: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/5/a58069fb13157422274c42a971a871beaf9edae2.png) This will take my text input date (12/20/2001) to output 20/12/2001 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/4/74813780dc4f68fc2ef9434cf247416f68a45c20.png) Hope this helps! ---
**Author:** ![victor.lucienbrun](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@victor.lucienbrun](https://community.make.com/u/victor.lucienbrun)\ **Post date:** [March 18, 2024, 1:52pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/6 "2024-03-18T13:52:48Z")
Thanks Nola, It’s working but when the day is superior to 12 tools ended with an error : ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/a/4ada19c7e8545f8ad541005794c4b85fe4d2e87d.png) ---
**Author:** ![Wemakefuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/wemakefuture/32/103_2.png) [@Wemakefuture](https://community.make.com/u/Wemakefuture)\ **Post date:** [March 18, 2024, 1:53pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/7 "2024-03-18T13:53:05Z")
@victor.lucienbrun maybe your date is a string and you have to use parseDate formula to transform string fromat in Date format. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/8/58507567d753f75ef8d2cb0f4bae4c4343ec8d7d.png) ---
**Author:** ![victor.lucienbrun](https://avatars.discourse-cdn.com/v4/letter/v/b77776/32.png) [@victor.lucienbrun](https://community.make.com/u/victor.lucienbrun)\ **Post date:** [March 18, 2024, 1:54pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/8 "2024-03-18T13:54:17Z")
This is the solution ! Thanks a lot ---
**Author:** ![Wemakefuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/wemakefuture/32/103_2.png) [@Wemakefuture](https://community.make.com/u/Wemakefuture)\ **Post date:** [March 18, 2024, 1:54pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/9 "2024-03-18T13:54:20Z")
🙂 I just saw that Nola already gave you the same answer. ---
**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:** [June 16, 2024, 1:04pm UTC](https://community.make.com/t/i-want-to-transform-a-date-in-this-format-dd-mm-yyy-to-this-format-mm-dd-yyyy/30834/10 "2024-06-16T13:04:03Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.