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" WorkflowRelevance AI - Access "Reformat Date Field" Workflow

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 wizardRelevance AI - "Reformat Date Field" workflow wizard

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.