Forum Discussion
How to replicate a Excel text-to-column date conversion
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 :)
Hi Sean thanks for this, I had thought about doing it this way just figured there might be a simpler way! I'll use this method for now until they improve the basic functionality. Much appreciated.
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 Locale
this should do the trick :)
radpir Thank you for this, from your answer I managed to find a solution. I actually had to add a step which was to convert my column to text format first, and then use Change Type > Using Locale but after that it worked perfectly.
Greg_Deckler Thank you for your suggestion, that would also have worked however radpir solution allows me to do it earlier in the ETL process.
Thank you both.