Rank Date

Hola @Manu.n

I can see you use the date format dd/mm/yyyy like any person in Latin America. May you test a possible bug I found with this format when anyone tries to write/change the hour in GDE manually?

1)- Create this 2 columns and write these values please

image

  1. Later, try to change the time value in any row. I’m going to change the value 12:40:00 to 1:30:00
    As you can see, the Date is 03/08/2021 (dd/mm/yyyy) and has to be read as 03 de Agosto de 2021 because my Regional Settings were set to work different to US format.

image

  1. but, when the new time value is set, the Month and Day were switched and the new Date is totally wrong!!. Glide thinks that March is August now and many problem begin

image

  1. If you change any value (time) again, Glide switches again Month/Day and everything looks fine :face_with_raised_eyebrow:
    image

To sum up my problem: try to modify a time value manually in GDE when a user has a Date-Time format different to US format can cause problems. The problem begins when Month and Day are <=12 and are together in the same value.

Can you test and replicate this issue please?

Thanks a lot!

2 Likes