Forum Discussion

AndySmith's avatar
AndySmith
Helper III
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

AndySmith's avatar
AndySmith
Helper III
3 years ago

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? 

 

 

SG083's avatar
SG083
Frequent Visitor
2 years ago

I tried this and I found that the reason it returned 0 rows was because the field _Today is now set to the date + time so instead of being 11/04/2024 it's 11/04/2024 10:00:00.

So instead of just looking for records on 11/04/2024, it's looking for records where today's date = "11/04/2024 10:00:00".  If there are no records that fulfill this time criteria it will return 0.

I'm now looking into the Time Zone solutions.