Forum Discussion
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?
let
Source = DateTimeZone.UtcNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last Refresh Date"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Last Refresh Date", type datetimezone}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "EST Current Date", each DateTimeZone.UtcNow()- #duration(0,4,0,0)),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"EST Current Date", type datetimezone}})
in
#"Changed Type1"
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 TeamIf 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
1 Reply
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 TeamIf 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