Forum Discussion
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. Please advice.
123ErrorAttaching samples images.
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.
4 Replies
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
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
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.
