Hello,
I have a birthday column but for some reason it’s showing the date 1 day off the actual date. I can see the actual date by clicking inside the cell, but when I click out and on the app, the date is 1 day less. I am attaching screenshots. By the way, it doesn’t matter if I turn time zone on or off. Any help is appreciated.
Which data source are you using, and how is the date value added?
Using glide data, imported from CSV. Thanks @Darren_Murphy
arrr, okay.
I believe there are some issues with the CSV import function. In fact I have an open ticket with Glide support after several issues I ran into with exporting data from one App and importing into another.
What does the data look like in the exported CSV file? If you open it in a text editor, how do the dates appear?
Actually I imported it from Excel, I first exported from google sheets, I am attaching how it looks like in both. The thing is that I see the correct date when I click inside the cell, so the date is correct.
I experienced something similar, but I’m not sure if this is the cause. I suspect it’s due to the format in Glide using 12:00 am, while another source uses the format 00:00. Try using the date and time format, it might help you see the problem.
Thanks @himaladin the date format doesn’t seem to make a difference. For now I use the math column and added 1 to the date…does the trick.