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.

tarunsingla's avatar
tarunsingla
Solution Sage
7 years ago

Could you click on one of the errors and confirm what is the error message? It could be the records that are not a valid date time.

 

Regards,

Tarun

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi

     

    Will there any option to correct this.

     

    Error pic attaching intoquestion  section.

    • tarunsingla's avatar
      tarunsingla
      Solution Sage
      7 years ago

      Looks like an issue due to the time zone designator in the data.

      If PDT or PST is not necessary, you may try removing the last 3-4 characters from your date column and then parse the date.

      If the timezone is required, you may try extracting the timezone characters from the date and replace those with the hours:minutes to be adjusted (+ -) and then combine the two to get datetimezone.

       

      Regards,

      Tarun