I have a data file being supplied by a vendor who can not follow directions. We have three date fields that they need to populate Start\_date, Process\_date, Report\_date. We require the format to be mm/dd/yyyy, however since they are sending the reports from different countries we get a hodgpog. dd/mm/yyyy or the correct mm/dd/yyyy. the problem is in the same column of date me get both formats.
Does anyone have any idea how i could validate a given value to determine if they used dd/mm/yyyy or the correct mm/dd/yyyy. Assume i am setting a parameter stdt = "givenvalue".