[SOLVED] Dynamic String -> Date Handeling
I could really use some help on this. I am making a program that reads dates that happen to be stored as Strings in an excel spreadsheet into my program. However I need to store them as some kind of Date object so they can be compared against later. The problem that I am having is, the source data (the String versions of the dates) are not consistent as the company I work for is Global and different regions use different standards for date formating. So I need a catch all to format my dates as MM/dd/yyyy and store them that way when the input data may be M/d/yy, d/mm/yyyy, yyyy/d/mm, yyyy/mm/dd, etc. If any one here has any suggestions, ideas, or could point me in the right direction I would greatly appreciate it. :confused:
Edit: Also the input data might contain actually month names/abbreviations not just their number, such as Oct/1/2009 October/1/2009.