Faceting to Check Date Formats

Use the data faceting function to check date formats.

Note: This operation is based on the validation rules defined in Validating Data.
This example shows how to use the faceting function to check the formats of dates in the VISIT column.

Procedure

  1. From the VISIT column menu, click Facet > Text Pattern Facet.
  2. In the VISIT facet panel, click count.
    The facet results shows that most of the dates are in the MM/dd/yyyy format.

    To modify the dates that do not conform to this format, see Transforming Date Formats.