# Importing date records into Big Tables **URL:** \ **Category:** Ask for Help\ **Tags:** big-tables\ **Created:** [March 24, 2023, 8:22am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623 "2023-03-24T08:22:19Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 24, 2023, 8:22am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/1 "2023-03-24T08:22:19Z")
Weird issue here - wondering if anyone else has the issue. It took me a while to fathom out what was happening. Imported a 65,000 row excel sheet into Big Tables. Import worked fine - except a date column shows 1 day earlier once imported than in the original sheet. For example my spreadsheet says, as an example, 9 October, 1923 - but when it gets imported into the Big Table it gets imported as 8 October, 1923. It’s almost like there’s a timezone thing happening somewhere. Has any one else experienced this issue? How do I fix it? It’s bizarre! Russ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 8:24am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/2 "2023-03-24T08:24:40Z")
Glide has a 0 time as PM… unlike most of platforms AM ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 24, 2023, 8:28am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/3 "2023-03-24T08:28:55Z")
…so would that account for what is happening? How would I fix it? Russ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 8:34am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/4 "2023-03-24T08:34:10Z")
I do not know if this is the problem in your case… try to subtract 12 hours from import… and do testing with many scenarios… In many of my Apps, I translate from Glide time format to Google Sheets format… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 25, 2023, 12:00am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/5 "2023-03-25T00:00:50Z")
@Jeff_Hager Have you seen this behaviour before? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [March 25, 2023, 12:09am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/6 "2023-03-25T00:09:01Z")
Where would one find “Big Tables”… Do I need to request they be turned on? ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 12:15am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/7 "2023-03-25T00:15:03Z")
No. It is only happening in Big Tables. I might report it to the development team as a potential bug. Russ ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 12:16am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/8 "2023-03-25T00:16:41Z")
Hi Eric, You need to apply to be part of the Big Tables beta test group. It is well worth it. Takes a standard Glide sheet from 25,000 rows max to millions of rows. I think you need to be on a paid plan to be part of the pilot. Russ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 25, 2023, 12:17am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/9 "2023-03-25T00:17:13Z")
I don’t know if it depends on the timezone you are in, or what’s happening. For me a date with no time seems to default to noon (12pm), where I would expect it to default to midnight. I can’t reproduce the situation where it jumps to the wrong day. Seems like the time jumps forward for me, but it jumps backward for others. Even in cases where ai specify a time, it jumps ahead 12 hours. Something is definitely off, but I can’t quite put my finger on it. I mention more on it is this post. > [@Problem with the 'text to date' - missing a day, what it wrong?](https://community.glideapps.com/t/problem-with-the-text-to-date-missing-a-day-what-it-wrong/59394/2): > > That does seem odd. It seems to be working correctly for me, but it also seems like Glide does incorrect things with dates sometimes. When you click on one of the cells in the date column, what does it show for the underlying ISO formatted date and time? I’m guessing it’s offsetting the time by enough hours to show the previous day. Have you tried playing with the Locale or Timezone settings? What happen when you put GMT as the timezone? What county do you live in? Another thing you could… ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 12:50am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/10 "2023-03-25T00:50:02Z")
Thanks Jeff - really great suggestions. The column is formatted as per the image below: ![date_column](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7066def3e61a6a914784553c4fcaefb0dc9b1036.jpeg) There is no ‘time’ included - just the date. I live in New Zealand - which typically is 12 hours ahead of the rest of the world - which would account why the date imported is 12 hours behind. I’ll check out the timezones thing - although wouldn’t have thought that would have been an issue with a column that didn’t include time. Confusing. Russ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 25, 2023, 2:37am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/11 "2023-03-25T02:37:35Z")
I’m only 6 hours of off GMT time, so I’m not sure where 12 hours comes into play for me, unless Glide is doing some kind of default time. If you click on one of the date cells, as if you were going to edit it directly in the table, it should show you the true date timestamp, including time in ISO format…unless it imported some other way. ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 2:46am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/12 "2023-03-25T02:46:58Z")
Wow - now you’ve confused the heck out of me!!! 🙂 Two images below - one shows the native format in the cell - the second - when I click on it. The first date is what is showing when I use that field in a screen - but the correct date (that was in the spreadsheet I imported the date from) is actually the second date. ![date1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0d8f38bbac8001bbf218c5948870e60719bf371.jpeg) ![date2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/027465118b481d65d3e51481e46f8d3f3027dbf9.jpeg) This is weird. Don’t even know where to start to fix this. Russ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 25, 2023, 3:59am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/13 "2023-03-25T03:59:28Z")
It’s important to know that the formatting for a date column (as well as a number column or a math column) is really just a forward facing format ONLY for display purposes. The true underlying value is still preserved. ![Screenshot_20230324-224913](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/61171c44a1ddd2a5d7be67e830c5fdc6914f97da.png) I think you have a bug that is worth submitting to Glide. I’ve seen a handful of weird issues ever since Glide introduced the ‘Respect Timezone’ feature for Glide tables. So maybe that is tied in somewhere, but for myself, it has appeared to work better in the US, so I can’t quite put my finger on the true issue. ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 4:22am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/14 "2023-03-25T04:22:53Z")
Thanks Jeff. I’ll check in with Glide. Regards, Russ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 25, 2023, 9:05am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/15 "2023-03-25T09:05:46Z")
Please get support from within Glide while the app is open by selecting the “?” button at the bottom right. That will bring you to a support page, which currently has an “Open Support Ticket” link. ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 25, 2023, 9:17am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/16 "2023-03-25T09:17:59Z")
Thanks I logged a ticket earlier with some screen shots. Russ ---
**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\ **Post date:** [March 28, 2024, 11:17am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/17 "2024-03-28T11:17:25Z")
I encountered a similar issue in Big table, where my CSV is dated 1/1/2018, but upon uploading, the time shows -8 hours to 2017. ![Screenshot 2024-03-28 at 7.16.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e17db519d8df1a6f70063193488f9c2f02759aae.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 29, 2024, 12:15am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/18 "2024-03-29T00:15:09Z")
Can we look into this @NoCodeAndy ? ---
**Author:** ![snooprussyruss](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@snooprussyruss](https://community.glideapps.com/u/snooprussyruss)\ **Post date:** [March 29, 2024, 12:52am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/19 "2024-03-29T00:52:50Z")
Glide were pretty unhelpful when I reported it last year. Despite screen shots and videos they were unable to replicate it - I think they thought I was smoking my socks :-). I suspect it is a time zone issue - I live in New Zealand and we are 8 hours ahead of the States - which is the amount the time is out by. In the end I had to create another column next to every date column with a formula to subtract 8 hours from it. It works but hardly elegant. Russ ---
**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\ **Post date:** [March 29, 2024, 3:17am UTC](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623/20 "2024-03-29T03:17:02Z")
I thought of this too, but I concur with you. However if I ever had to upload a clients CSV, it would be difficult to explain….