Problems Datetime in glide tables

First time reporting a bug? Refer to our Start Here post.

I have my table in Glide and a column called “FechaAprobacion” of type Date, from another process using the CallApi I fill this column, but the problem is that when displaying the information it is shown incorrectly, for example I register the date 08/05/204 10:36, but in the table visually it is shown as 5/8/2024 05:36, but when I double click on the record the date is displayed correctly, you have to edit the field directly in the table to fix it. What could be causing this problem?

This is the structure of the field

This is the API that is responsible for updating the value
1.1

Here we can notice how the date says 5/8/2024 which is incorrect
2

Here we can see that when the field is edited it shows the correct value 8/5/2024
3

Team ID:

  • In the Glide dashoard URL, e.g.
    https://go.glideapps.com/o/your-team-id-here/

App ID:

  • In the Glide builder URL, e.g.
    https://go.glideapps.com/app/your-app-id-here/layout

Description

  • Tell us what’s happening.

How to replicate

  • List the steps, in detail, for recreating the issue.

Are you expecting August 5th or May 8th? If dates are entered with an ambiguous format like that, it’s almost impossible for software to know what you meant, especially when it’s designed to work with both formats like Glide does. (DD/MM/YYYY and MM/DD/YYYY)

I recommend using a YYYY/MM/DD format which is internationally recognized, or better yet a full ISO 8601 standard date and time format.

2 Likes