Forum Discussion
Solved
How to replicate a Excel text-to-column date conversion
I export data from one of our services and the dates come out in mm/dd/yyyy format. In Excel 2016 I can convert this very easily to dd/mm/yyyy in place without having to create any new columns. T...
there's a simpler way to do it via the PQ GUI:
right-click the column and then go Change Type => Using Locale...
then in the Dialog box select Date for Data Type and English (United States) for Localethis should do the trick :)
In your data model, click on the column. Click on "Modeling" tab. Under data type, click on "Format" drop down and choose the format that you want.