How To Calculate Date and Time using Offset


I am using DateTimeNow() function to get the last refresh date of my data table. However, because the system is located in Australia, the system time is shown in Australia Western Standard Time (i.e. UTC+8).

Is there a way to calculate the UTC by substracting the result from DateTimeNow() function by 8 hours?


(1) Answer