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 hel...
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.
amitchandak
Super User
Super UserAnonymous , Try DateTimeZone.FromText function out
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromtext
I have not tested this