Hi Glide team,
I found a wierd bug with the way glide read dates from google sheets.
When I use the numeric value of a date (for some reason my sheet is showing for new rows the numeric value and not the date format althought the column’s format is set to date format) glide is reading the value wrongly.
in the example below the value in my sheet is 44256.92696 which if you format it as date is equal to 2021-03-01T22:14:49.069Z but when I look at the data in the data editor wnd the column is set to date glide read it as 1/1/1970, 12:00AM
this is the sheet: (the function in column C determine if the user entered manual date (using date picker) in column B and takes it or else use column A (which is the “current date/time”) is ARRAYFORMULA(IF(B2:B="",A2:A,B2:B)):
the data as shown in the data editor:
as glide read this wrong my sorting and calculation based on this column are not wotking correctly.
if I copy the format of the cell above and replace the format from nu,bers to date glide read it correctly (not changing the value - just the format)
appreciate your help in solving this.