# Dates not being recorded properly **URL:** \ **Category:** Get Help\ **Created:** [September 24, 2020, 7:40am UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322 "2020-09-24T07:40:37Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [September 24, 2020, 7:40am UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/1 "2020-09-24T07:40:37Z")
Hi, I have an airtable base with following fields: Date - in airtable Europen date format Date to send to ADalo - a text copy of the Date field I did it like this, because in “Select” fields in Adalo, it does not pull data from Airtable Fields. The issue is that now when I select a certain date to save, the database records a totally different field (my database field is in Date format) so data flow is from text in airtable to date in Adalo. I believe this is happening due to Adalo being in US date format? How to overcome this, do we have a format formula? Example, I made a saving as “30/10/2020” and date was recorded as “11/8/2020” Thank you.Jorge ---
**Author:** ![vancewong](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vancewong](https://forum.adalo.com/u/vancewong)\ **Post date:** [September 25, 2020, 12:08pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/2 "2020-09-25T12:08:36Z")
The date and time format Adalo uses is UNIX. So it’s in UTC+0 time zone. You’ll probably have to convert the Airtable field data to fit that format so that Adalo can read it ---
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [September 25, 2020, 1:39pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/3 "2020-09-25T13:39:10Z")
Yeah, that was what I was afraid. I need to have then a proper text field to send in frontend and emails. ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [September 28, 2020, 8:16am UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/4 "2020-09-28T08:16:27Z")
> [@sebastas](#): > > Example, I made a saving as “30/10/2020” and date was recorded as “11/8/2020” Can you provide me the app and screen where this happens? This should not be the case and I would like to investigate more. ---
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [September 28, 2020, 9:14pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/5 "2020-09-28T21:14:14Z")
Hi Colin, You can check the app “Jazta Copy Copy” ![image.jpg](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/8f9ea5ee025806d116f368c8ca78c9a25c01637f.jpeg) Best, Jorge Marques ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [September 29, 2020, 11:33am UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/6 "2020-09-29T11:33:05Z")
Seems to be working ok for me? ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/103a5aff77c9b122700cdad3e6c3c44233ee3efa.jpeg) ---
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [September 29, 2020, 11:58am UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/7 "2020-09-29T11:58:01Z")
Hi Colin, Frontend is fine, but when you book, in the DB is wrong. I just booked using name “test299”, I choose date “29/09/2020” but in the DB date is “10/13/2020” Data input is “dd/MM/yyyy” while DB is in “MM/dd/yyyy” thus doing a wrong conversion, but I do need the DB in date, since I will then need to apply delete mass if date less than XXX. Thanks ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/62adc09e1dec0d678365df98a5b582461bf9514d.png) ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [September 29, 2020, 1:06pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/8 "2020-09-29T13:06:54Z")
Ok that is indeed bizarre! I have sent this in to the team. ---
**Author:** ![sebastas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sebastas/32/3447_2.png) [@sebastas](https://forum.adalo.com/u/sebastas)\ **Post date:** [September 29, 2020, 6:23pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/9 "2020-09-29T18:23:02Z")
Hi Colin, No need, my fault, I have a process that copies the data from formula to a text field (Since Adalo in Select does not accept Airtable formula fields), I didn’t have the automation running in Airtable to update the fields data. so copied wrong ones. My apologies :). ---
**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:** [October 9, 2020, 6:23pm UTC](https://forum.adalo.com/t/dates-not-being-recorded-properly/4322/10 "2020-10-09T18:23:06Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.