Export to excel: Customize datetime format

[Martin]

Hi. I have a PivotGridControl with an OLAP datasource. 

I use the method ExportPivotGrid in the server side (equal to the example in the online documentation).

The PivotGrid has several column with date and time, but with zero in the time part, like "2015-10-17 00:00:00.000".

How can I show only the date part (only "2015-10-17") in the columns, without the time part? in both the web and the Excel file

Thanks!

[Ramesh Govindaraj]

Hi Martin,

Thanks for using Syncfusion products.

We regret to let you that currently we don’t have support for DateTime format option. In all our Syncfusion BI components we will process information only via Microsoft’s ADOMD provider. Here Microsoft’s ADOMD provider, it returns the date in that format and we have displaying at same format. So, kindly change date format in cube level.

Regards,
Ramesh G.