Custom Date Format

When you connect to a datasource, Zoho Analytics automatically interprets the data type of the columns in the table and assigns the same accordingly. Similarly, the existence of a date column in the data that you are importing into Zoho Analytics is auto-identified and an appropriate date format is assigned. If in some cases, the date columns are not auto-identified correctly, you can either choose the date column from the default list provided or create a custom date format to suit your needs.

This Date Format guide briefs you about how to construct a custom date format.

Setup the date format from Import Wizard

While importing data into Zoho Analytics, Zoho Analytics assigns a date format to the column containing the date. You can change the format of the applied date if required. To do so,

1. In Step 3 of Import Wizard, click Format of Date column(s) drop-down menu.
2. In the Choose your date format pop-up page, you can either choose from the list of available options or provide a custom format in the Enter your date format if it is not listed above text box.

Setup the date format from Import Wizard

You can set the date column format for a column in an existing table in Zoho Analytics. To do so,

1. Open the required table in Zoho Analytics.
2. Right-click on the column containing the date. A list of all possible activities with the column will open.

3. Select Format Column.

4. In the Format Column pop-up page, you can either choose from the list of available options or provide a custom format in the Enter your date format if it is not listed above text box.

Reference Table - Date Format String:

The following table captures all the format strings (or abbreviations) and their meanings for your reference. Note that you could also provide any special characters (slash, comma, hypen etc.,) as part of the format strings to capture such characters that could be part of your date value.