Date fields do not have formats. Formats are applied by the presentation layer.
If you are storing "dates" in character fields, STOP IT!!!!! You should use the correct data type for the data. Dates should be stored in DATE/TIME fields not strings except for storing them TEMPORARILY in string fields when loading data so that you can check for invalid dates.
J. Drew Allen
Business Intelligence Analyst