Since I couldn't rely on what format the date would be in...

You might consider using one of the modules that provide date/time parsing. I tend to use Date::Manip myself, but there are others.