Forum Discussion
Applicable88
Impactful Individual
Impactful IndividualM-formula for the Server offset
Hello, since the server runs in UTC i have 2 hours difference. The problem is that I have a calculation running for specific days. I used the a formula to offset the hours: Time.Hour(DateTimeZone...
You should be able to use this as your core expression and then wrap it in whatever you need to get your desired results.
= DateTime.LocalNow() + #duration(0,2,0,0)
For example, if you wrap it in Date.From, you will get tomorrows date (if it is >10 PM).
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeYou should be able to use this as your core expression and then wrap it in whatever you need to get your desired results.
= DateTime.LocalNow() + #duration(0,2,0,0)
For example, if you wrap it in Date.From, you will get tomorrows date (if it is >10 PM).
Pat