Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago
Solved

Get the right date from time switch zone function

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. 

 

Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

2 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!