Zoho Reports allows you to quickly and easily import your data from numerous formats then change data types on the fly allowing you to do complex data manipulation and get the most out of your BI reporting solution.

Zoho Reports allows you to change data types during or after data import. For example, date formats, which are often tricky and inconsistent may be exported as text in one application, but can be quickly converted to the format you require in Zoho Reports.

You can follow the below steps to change the column to Date type:

- Open the base table on which you have created the view.

- Right click on the Closing Date column and select Change Datatype menu item.

- In the data type wizard, change the Datatype from Plain Text to Date in the dialogue.

- To choose your own date format, click on the Choose Format button and select the required format and click OK.

- Now open your view and the field is defined as a date type.

From there you can define User Filters (new feature) and add date ranges such as from / to dates, general date ranges (last month, last quarter etc), or specific date filters.

For details on how to do that.... check out my other blog!

 

Tags: zoho reports