# Date format in Adalo collections and Text Input Fields **URL:** \ **Category:** Get Help\ **Created:** [July 30, 2021, 2:40pm UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481 "2021-07-30T14:40:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Amadog](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/amadog/32/10148_2.png) [@Amadog](https://forum.adalo.com/u/Amadog)\ **Post date:** [July 30, 2021, 2:40pm UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/1 "2021-07-30T14:40:28Z")
Hi, I live in Australia and our date format is dd/mm/yyyy. When I add a record into my collection with a date field it shows as mm/dd/yyyy. When I represent that in a desktop app in a Chrome browser in a text input field it comes out as mm/dd/yyyy. Also when I utilise a date picker component and set its style to “Date Text Input” the date picker formats as dd/mm/yyyy on the desktop app (which is great). However when I set a Text Input Field to equal the date picker contents and set the Text Input Field to the date format mm/dd/yyyy (only option I have) the Text Input Field shows as mm/dd/yyyy. Therefore the date is never stored or retrieved and displayed in the right date format for me (dd/mm/yyyy). I would really appreciate some advice on getting data in collections to store as as dd/mm/yyyy. If collections cannot store dates as dd/mm/yyyy that’s ok but then it should display on my browser in my region/locale dd/mm/yyyy. Thanks ---
**Author:** ![Amadog](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/amadog/32/10148_2.png) [@Amadog](https://forum.adalo.com/u/Amadog)\ **Post date:** [July 31, 2021, 2:52am UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/2 "2021-07-31T02:52:07Z")
Changed the Chrome Language settings to English Australian as primary language and the dates show correctly as dd/mm/yyy. The dates in the collections DB still show as mm/dd/yyyy. But thats ok. Link on how to do that is [here](https://support.google.com/chrome/answer/173424?hl=en&co=GENIE.Platform%3DDesktop) ---
**Author:** ![Ash1](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@Ash1](https://forum.adalo.com/u/Ash1)\ **Post date:** [August 1, 2021, 7:44pm UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/3 "2021-08-01T19:44:01Z")
I’ve come across a similar issue where my collection data is in the correct format for me (dd/mm/yyyy) but it is then displayed as mm/dd/yyyy which makes the date completely wrong. If I display todays date for example as set the date as relative Adalo says that it was 7 months ago. I’ve tried your suggestion above but it hasn’t worked for me ☹ ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d75d5904893a6d8040d67e7eec155c8bed7417c2.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/6e581c42c09e571695ac7045c1709138b39acf65.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/4/40fe40467c5d1c4e94c2bc23addb465686c9be85.png) ---
**Author:** ![Amadog](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/amadog/32/10148_2.png) [@Amadog](https://forum.adalo.com/u/Amadog)\ **Post date:** [August 10, 2021, 2:44pm UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/4 "2021-08-10T14:44:49Z")
Hi @Ash1, Its been a while, sorry for the late reply. But is it still a problem. Did you refresh browser, restart browser and restart the Adalo app? Are you using Chrome, Edge, Firefox etc? ---
**Author:** ![Ash1](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@Ash1](https://forum.adalo.com/u/Ash1)\ **Post date:** [August 11, 2021, 9:44am UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/5 "2021-08-11T09:44:04Z")
Hi @armorofgod - thanks for the reply. It’s still a problem unfortunately and to answer your questions: 1 - Yes, i’ve done all of the ‘off and on agains’ 2 - I’m using Chrome I actually think the issue is likely caused by the way I’m receiving the data in the first place. I have an API call that gets the information and stores it in a google sheet. The data information from the API comes in the format yyyy.mm.dd (with full stops to separate). To show it how I want to I’ve then formatted the google sheet column with a standard date format that puts it into dd/mm/yyyy and then an Integromat automation takes this information and puts it into my Adalo collection. The dates in the collection database display how I want them to as pictured above but when it’s displayed in the app it shows as mm/dd/yyyy ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [August 21, 2021, 9:44am UTC](https://forum.adalo.com/t/date-format-in-adalo-collections-and-text-input-fields/15481/6 "2021-08-21T09:44:05Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.