Hi, I think this is a bug so I’ve raised it under this topic, hope that’s OK. Team ID: DicJQdwfYZ8IFrkf1dfM App ID: KvYy4BKLNCngUHriZrjO OS/Browser: Windows/Chrome Description I’m importing a CSV file with 3 date fields. All 3 fields have the same data format (date: dd/mm/yyyy) in the CSV…

sorry I’m not authorised to upload a CSV file here.

Dates in dd/mm/yyyy and mm/dd/yyyy are always ambiguous. There is no way for a computer to reliably determine the intended format. I would recommend always import dates as yyyy/mm/DD which is understood internationally. I think starting with that would clear up a lot of issues. If dates are stil…

Thanks for that advice @Jeff_Hager - I didn’t know that yyyy/mm/dd was the accepted standard format. I guess I’ll change my source data before importing it and then reformat it in Glide as needed. I’ll try the options around the ‘respect timezone’ and see what happens. I can’t use that setting in t…

Share what you find out. Dates are finicky to work with, especially when they come from an outside source and there are so many different formats to consider.

In addition to what Jeff said, this is a good read from @Darren_Murphy regarding dates in Glide. [image] Big Tables - date/time column offset issue Ask for Help Well, that response you got from Support is not what I would have expected, so I just did a bit of testing. I …

Thanks very much @ThinhDinh for the link to @Darren_Murphy ’s post. Very helpful post thanks Darren - I followed your approach to test both with Glide tables and Glide Big Tables - something I did not expect would treat data differently, but there is quite the difference! It’s essential I found thi…

Glide Date issues when importing a CSV file

Report a Bug

ThinhDinh April 26, 2025, 12:05am 6

In addition to what Jeff said, this is a good read from @Darren_Murphy regarding dates in Glide.

Topic		Replies	Views
Date fields behaving oddly when importing from CSV Ask for Help	1	49	June 30, 2024
Problem with dates when uploading database Report a Bug data-sync	13	159	October 16, 2024
New problem with importing dates Ask for Help	15	109	July 7, 2024
Date format keeps changing Ask for Help	5	50	September 12, 2025
Date problem Ask for Help	4	240	July 13, 2023

Glide Date issues when importing a CSV file

Related topics