Iām looking at this closer. I think I get whatās happening now. I think it only affects you for the last 8 hours of the last day of the month. I wonāt see it until the first 5 hours of October 1st since Iām on the other side of GMT.
The confusing thing here that when you add GMT to the date/time in a template column, then glide assumes the date/time as if it was actually GMT. So when you show that GMT time or pick out the parts of the GMT date, then the equivalent of Singapore date/time is 8 hours after the GMT date/time, which was pushing the date to Oct 1st. My logic to add or subtract 24 is applying somewhat correctly, but in the wrong direction. Itās supposed to offset a difference of -16 by adding 24, but instead it subtracts 24, which gives you an offset of -40.
I quickly tried a change which fixes it on your end of the world, but not on mine. Iāll have to rethink the logic a little bit and hopefully update the formula. Basically Iām trying to use the below part of the formula to get a -1, 0, or +1 if the month changes, then multiply that value by 24, so the hour difference can be adjusted properly if it crosses different days. I have some ideas to fix it, but Iāll have to do some good testing. Iāll let you know when I have it fixed.
That explains why it worked for my boy in Melbourne last night when I asked him to test - because it had already ticked over into the new month down under. It also explains why it didnāt work for our friend in Vietnam on his Windows machine - because it was still in that 8 hour āblack holeā period in Vietnam. So the OS theory was just a red herring
At least we know whatās going on now, and the good news is we have a whole month (almost) to figure out how to fix it!
Edit: Just quickly tested for a few days other than the first/last day of the month, to make sureā¦
really? nobody mentioning 12h off GS vs Glide? and different 0 dates? and why going this circus when we can relate to absolute time numbers?
time Apps by StructureArt:
The reason I am persisting with this is because itās a pure Glide solution that requires no Spreadsheet formulas, and no experimental columns, and nothing else external to Glide other than the users own device. If you can show me an alternative solution that meets those criteria, then Iām all ears
try to put ā0ā on Date cell format in GS and Glide and see what happensā¦ Glide is the base origin GS app creatorā¦ so ā¦ letās stick to GS formats @Darren_Murphy by absolute numbers I mean time duration, related to TIME NOW on active Appā¦ and I just post 2 apps that have this problem solved
@Darren_Murphy Grrr, this would be so much easier if glide would recognize a template date as a date for date math. They will let me pick out parts of a template date, such as Day and Hour, but it wonāt work for simple date math. Not sure why.
But I did figure it out and I think I have it fixed. I tested with both my timezone of GMT-5 and your timezone of GMT+8. I also tested within a couple hours of the end of the day on Sept 30th and the beginning of the day on Oct 1st. I also tested a random day in the middle of the month. In all cases it showed me the correct offset and correct GMT time regardless of user timezone.
TIME is a var that relates to a user position in space and speedā¦ thatās why I will suggest using durationā¦ and recalculate time in USC for usersā¦ and have anchor point in GS for App developer
guysā¦ have fun cracking time formatsā¦ like a said ā¦ make a duration as absoluteā¦ and add to timeā¦ my apps are unbreakable for customers around the world! and they always come for more.
Finally!
