Skip to main content

Symon.AI help center

Date format

Change one or more columns from Text to Date or from Date to Text.

When to use this tool

Use when you want to change a date column to text or change a text column to a date.

Salesforce export usage

If you want to modify the date column and use it for export to Salesforce, you must use a specific format. Salesforce supports the following format: yyyy-mm-ddT00:00:00.000000Z.

Since the data set needs to be exported to Salesforce, if you use the Date format tool, ensure that configuration is custom: %Y-%m-%dT00:00:00.000000Z.

You can also leave the original format as-is if you don't want to use the Date format tool to format the date.