Custom component showing different date that what was picked

I have a date picker and a field in a custom AI component that shows the information that’s on the column where the date picker anotates. I don’t know if it has to do with the AI, with timezones or what issue, but whenever I pick a date it shows another completely different one.


Here’s my date picker


Here’s the column it writes to (I have tried both respecting timezones and not doing so)


Here’s the custom component, note that it shows 20 nov 2024, although the column clearly indicates 11/21/2024.

It’s the same date using different display formats. Try adjusting the language/regional settings in your browser.

Sorry I don’t understand, the issue is my browser? What can I do if my clients are the one who use the app and not me? Is there not a way within glide where I can make adjustments so the shown date is exactly what they chose and in their timezone?

Found a solution. I realized that if I used the date picker instead of date and time picker, it always picked the hour at T00:00:00.000Z which is what brought me issues. I added a math column and added 0.2 hours so it would not be in midnight and is now showing the correct date.

That is exactly what should happen. Dates and times should be shown respecting each users language/regional settings.

ah, my apologies. I missed that it was showing as two different dates.
Question: do you have the “Respect Time Zones” option selected on the date column?

Hola Valeria!

As Darren advised you, it is a good practice use “Respect Time Zones” option in your Date column to avoid issues with date/time from several devices.

I have an AI component similar to yours. I initially had the same problem you describe, but a modification to my prompt fixed it. Here you can see some of my instructions to fix my date/time problem.

Saludos!

1 Like