Forum Discussion
Date formatting with different date formats
Hi everyone,
I need help this is driving me crazy. It started with a new company.. I pulled their data and they have customers that enter dates in different formats. It’s basically a free-form field.. with text data, Different formats, periods, partial dates... I’ve tried everything I could think of there’s even an extra enter space is an additional dates underneath in the same column and row I really need help please... how do I convert these dates to have a clean data source to work with?
I need help this is driving me crazy. It started with a new company.. I pulled their data and they have customers that enter dates in different formats. It’s basically a free-form field.. with text data, Different formats, periods, partial dates... I’ve tried everything I could think of there’s even an extra enter space is an additional dates underneath in the same column and row I really need help please... how do I convert these dates to have a clean data source to work with?
1 Reply
Hi Angela,
It very depends on how your data looks like, better if you provide small sample with what you have and what you'd like to have. As variant, if your data in one column you may try Data->Text to Columns and on third stage apply Date and select source date format.
