Forum Discussion
Solved
Today() Function - UTC Offset
Hi Apologies in advance - as I have seen several posts on this already - but I am just struggling to make sense of any of it! I have a measure which uses the 'today()' function to work out the pre...
Hi AndySmith ,
Please try to use NOW().
Column = NOW()+TIME(10,0,0)The column=today()+time(10,0,0) represents 2023/1/19 10:00:00.
Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks
I have tried to go with option 2! I have added 10hrs to the 'TODAY()' function.
Sadly this seems to return zero! Any ideas why this may be the case?
Hi AndySmith ,
Please try to use NOW().
Column = NOW()+TIME(10,0,0)The column=today()+time(10,0,0) represents 2023/1/19 10:00:00.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.