Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time Zone Error

Hi,   I am getting error when I change the data type to date/time/zone.   Input data has values like mm-dd-yyyy hh:ss:mm timezone. When I change the data type to time-zone its giving error. Pleas...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    First split column

    Then add a custom column

    Custom=
#datetimezone(Date.Year([#"date-act.1"]),Date.Month([#"date-act.1"]),Date.Day([#"date-act.1"]),Time.Hour([#"date-act.1"]),Time.Minute([#"date-act.1"]),Time.Second([#"date-act.1"]),-7,0)

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

First split column

Then add a custom column

Custom=
#datetimezone(Date.Year([#"date-act.1"]),Date.Month([#"date-act.1"]),Date.Day([#"date-act.1"]),Time.Hour([#"date-act.1"]),Time.Minute([#"date-act.1"]),Time.Second([#"date-act.1"]),-7,0)

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.