i never noticed about the time. i think 12:00 AM still ok ?
This condition will cause a difference of half or one day. I forgot how I finished it before. While I’m not close to the computer. If Glide writes 12.00 am then G. Sheet will think it is 12.00 PM. But, I am not sure.
Try manually forcing it to change it to 0.00, will your problem still occur.
Try replacing your date picker component with a new one, does it still say 12.00?
with the same component ?
Yes, throw away your date picker and replace it with a new one. I prefer the 24.00 hour format
Maybe @Darren_Murphy can explain this. The point is, make sure all the formats are the same, because this is related to you making time comparisons.
If you’re having trouble testing in the browser, you can use time date pickers. Force the time selection to 0:00, while keeping the filter active, to see if the 12:00am time format is indeed the cause.
but i did this test right?
its same thing happen.
Bukan dalam tabel tetapi di aplikasinya. Memang, pemilih tarikh Glide menghasilkan 12.00AM. Apakah keputusan dalam penyemak imbas jika anda menggunakan pemilih tarikh-masa dengan memaksa masa menjadi 0.00 pagi. Apakah aplikasi anda berfungsi. Jika ya, maka ini adalah masalah dengan komponen Glide.
Saya sangat berharap semua format disamakan kepada 0.00 semua untuk menghapuskan masalah ini
Yeap!
Is it still a problem?
Is it the same as in G. Spreadsheet (not in Glide)?
Yes, correct.
But in this case i have to use USC right.
It’s not just a USC problem. Do you have item time list data recorded in a spreadsheet?
yes i do have.
i’m still using Google sheet for this app
Ya, bandingkan saja apakah kedua formatnya sama tidak -lah.