Get the right date from time switch zone function

[Applicable88]

Hello,

I use this function to work against the utc+2 time lap:

Time.Hour(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),2,0))

I have different calculation based on different times.

I wanted to get the right day as well. For example when its already 1am the server is still 23:00.

And so I need a function which not tells me the time.hour but the day whe are in, including the time lap of course.

When I do the following I always get year 1899:

Date.From(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),2,0))

Is there a workaround to get the "right" day from client point of view?

Thank you in advance.

Best. 

[v-kelly-msft · Accepted solution]

Hi  @Applicable88 ,

Use below M code to get the right day:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtQ31TcyUDA0sDIyc/RVio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Datetime = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Datetime", type datetime}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTimeZone.SwitchZone(DateTimeZone.From(DateTime.LocalNow()),2,0)),
in
   #"Added Custom"

DateTimeZone.SwitchZone(DateTimeZone.From(DateTime.LocalNow()),2,0)

pls check my .pbix file attahched.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Applicable88]

thanks @v-kelly-msft !