(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

Intelligent Date Formatting

Detect Date Format button:

Click the button will show the most popular format as Custom format

If no valid format is detected, an error message will be displayed.

Validate button will be displayed when a date format is selected.

If validation failed for any cells in a column, error message will be displayed.

You can detect and validate more than one column.

Inline help will show up when user pick date format or mouse over the DateFormat drop-down box: