[SOLVED] Dynamic String -> Date Handeling

Hello again,

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:

Mr C.

Edit: Also the input data might contain actually month names/abbreviations not just their number, such as Oct/1/2009 October/1/2009.

I recommend looking into java.util.Date, and java.text.SimpleDateFormat. That's what these two classes are all about.

Thank you for the help.

I took a look at SimpleDateFormat and was able to put something together that would work for formatting the dates. Still not as dynamic as I'd like it to be but it is to the point where it works.

Thank you again.

Mr. C