Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DateTimeZone.UtcNow() Daylight-Standard Time

I created a custom column current datetime in est.   It is 1 hour ahead, of standard time.    How to I set the datetime in power query -1 hour back when standard time starts on November 5?   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Please try:

     

    if Date.From([Last Refresh Date])>=#date(Date.Year([Last Refresh Date]),9,5) then DateTimeZone.UtcNow()-#duration(0,5,0,0) else DateTimeZone.UtcNow()-#duration(0,4,0,0)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Please try:

 

if Date.From([Last Refresh Date])>=#date(Date.Year([Last Refresh Date]),9,5) then DateTimeZone.UtcNow()-#duration(0,5,0,0) else DateTimeZone.UtcNow()-#duration(0,4,0,0)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum