I’ve come across an issue where I can’t seem to get the date to print the correct time within a formula.
Please see example, I’ve stripped it down ot its bare bones.
On the left is a date (and the time is correct). On the right is that date reprinted as a function. It appears to be an hour off.
This is the formula for the function (simply reprinting the date):
It also gives the same result (incorrect) if I set the time to my time zone, which is GMT.
Any help appreciated