I am working on a check in/ check out system for a local studio. I’ve hit a problem that I can’t find a solution for elsewhere.
The image below shows the problem. The second row should show a “” as the Last Check In is 1 minute after the Last Check Out, however the difference between the two times (using DATETIME_DIFF) is showing as 58 minutes.
I think the problem is caused by DATETIME_PARSE on another table not correctly setting the timezone (see below). If I have “GMT for all collaborators toggled on” it shows the correct time (as above) but is still being treated as the correct time + 1 hour
Any ideas what is going on here? Or how to get around the parsing issue? Any help would be greatly appreciated!