Don’t trust anything that Jeff guy says:
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.
(24 * (ABS(day(GMT)-day(LDT)) / (day(GMT)-day(LDT))) )