In the Datetime Format dialog, you can specify or locate the format that you'd like to use for validation of the values in the current column against the Datetime data type. For example, if you choose mmddyyyy as your format, all values in the column are considered valid for the Datetime data type if they fit the mmddyyyy pattern. Otherwise, they are considered invalid values for the Datetime column.

Choose Datetime Format dialog

NOTE: The list of available Datetime formats is factored based on your current locale settings. Some formats from other locales may be available for selection. For more information, see Locale Settings.

To locate a format, you can:

For more information on the supported tokens for the Datetime data format, see Datetime Data Type.

To apply your selected format, click Select Format. The values in the column are validated against the selected format for the Datetime data type.