Forum Discussion
Date Time Conversion Error
Hello,
I have survey data that has a DateTime in Text format. When I changed the type to Date/DateTime, it produced errors. Can anyone help me to work around this problem?
Thank you for your help.
Anonymous your column contains timezone information, first change the type to date timezone, and then in the next step change it to date or date/time based on your need.
3 Replies
Anonymous your column contains timezone information, first change the type to date timezone, and then in the next step change it to date or date/time based on your need.
Anonymous , Try DateTimeZone.FromText function out
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromtext
I have not tested this
