I wasn’t avoiding the date time query.
I have serious reservations about the Text to Date Plugin. It is letting me do stuff I should not be able to do such as converting digits into month when under 12 but switching to days when more than 12. This is beyond weird behaviour on its part. I’ll have a few examples in the plugins app. For now and until such time as the plugin is fixed I’m manipulating JS getUTC with other date time plugins. I have added some notes but you won’t see anything on your copy (your second thread )
Even though I have not yet put the advanced manipulations on a tab (work still in progress) all the JS date time returns are there (check advanced manipulations in the editor). You can always get JS to get you your local time without doing a single time offset calculation. There is an explanation on the basic manipulations tab at the very bottom on how to go about it but in glide we need 3 JS columns for that, so it’s not worth the trouble.
I’ll be back soon - need to get these manipulations out of the way.