LoosinMaMind (3/25/2013)
There must be some way of splicing up the date so you can check to see if "dd" is between 1-31 and the "mm" is between 1 and 12 etc etc.
This way you could Id the dates that have been entered in the wrong format.
What if someone has entered 3rd August 2013 as MM/DD/YYYY? That comes out as 08/03/2013, which also corresponds to the perfectly valid date 8th March 2013 in DD/MM/YYYY format! Unless you have some sort of context for the date that you can cross-check you're not going to be able to catch instances like that.