# 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:** 1\ **Showing post:** 9
**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… --- _[View the full topic](https://community.glideapps.com/t/importing-date-records-into-big-tables/59623)._