It’s 0650 in the UK on the 20th July.
Yet when i use the today() formula is still thinks it’s the 19th July.
What am I missing?
Most probably your time zone settings should be updated.
Boom! Thanks, knew it would be something simple.