Reformat Date Fields
Change date values structure to the format acceptable to the Relevance AI platform
There are a variety of formats under which date values are registered, dd-mm-yy
, and mm/dd/yyyy
to name a few.
For the Relevance AI platform to identify date values, they must be under the yyyy-mm-dd
format. You can make the required changes under software like Excel or use Reformat Date Fields workflow.
How to reformat date fields on Relevance AI
Once you have uploaded your data, select your dataset, click on Reformat Date Field under Workflows and follow the configuration wizard.

Relevance AI - Access "Reformat Date Field" Workflow
First, you will be asked to select the field with date values in your dataset. Next, either select the date format in your dataset or select "Auto Detect". And finally, Execute the workflow.

Relevance AI - "Reformat Date Field" workflow wizard
When the workflow is finalized a new column is added to your dataset containing the equivalent date fields but under yyyy-mm-dd
format.
Updated 4 months ago