Reformat Date Fields

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.

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.

When the workflow is finalized a new column is added to your dataset containing the equivalent date fields but under yyyy-mm-dd format.