Time Zone Error

[Anonymous]

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. Please advice.

123ErrorAttaching samples images.

[v-juanli-msft · Accepted solution]

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]

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]

Hi

Will there any option to correct this.

Error pic attaching intoquestion  section.

[tarunsingla]

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