Hi,
I have incoming data with a mixture of date formats. EG:
31-1-05
1-31-2005
1-31-05
1/31/2005
31/1/2005
There is a huge amount of data and I really do not have time to sift through and manually change everything. Is there a quick way to get all the dates in uniform formatting?
hello kp1983,
Have tried to define your Date Format settings in the Control Panel, Global settings?
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Select all the dates and use Text to Columns. Delimited, no delimiter required. Choose Date and MDY and Finish
If you have inputs like this ...
1/31/2005
31/1/2005
... you're in for some heartache. The first must be m/d/y, and the second must be d/m/y, but that leaves you to wonder what
1/2/2003
... means, because either interpretation is valid.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks