change to string to date RRS feed

  • Question

  • IN my power query table I have a column that has dates like this: Apr 9, 2016 2:00:17 AM PDT. It shows up as string and when I change to date it returns an error. How can I fix this so it reutrns a date? 
    Wednesday, March 8, 2017 7:42 PM


  • Hi Alex. To do this, you'll need to first replace the timezone indicator with the numeric offset (e.g. replace "PDT" with "-7"). Then convert the column to Date/Time/Timezone, and it should work.

    Or, if the timezone isn't important, just remove it (e.g. replace " PDT" with "", or remove the last four characters) and then convert the column to Date/Time.


    Friday, March 10, 2017 7:01 PM