We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Export to excel: Customize datetime format

Thread ID:





120815 Oct 18,2015 02:34 AM UTC Oct 19,2015 12:47 PM UTC ASP.NET MVC 1
Tags: PivotGrid
Asked On October 18, 2015 02:34 AM UTC

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


Ramesh Govindaraj [Syncfusion]
Replied On October 19, 2015 12:47 PM UTC

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.

Ramesh G.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon