This is a migrated thread and some comments may be shown as answers.

Excel Export of DateTime Value Not Exporting Time

4 Answers 133 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Rodney
Top achievements
Rank 2
Rodney asked on 01 Apr 2016, 06:48 PM

I have a column in my grid that is defined as DateTime. In the grid, it displays correctly as "01 APR 2016 14:25". When I export to Excel I get "01 APR 2016 00:00" I've tried a number of things listed, but no luck I'm using an ExportSettings-Excel-Format = "Xlsx". In my current iteration, I have no code that would modify the column just the HTML below. Based on what I've seen in the Doc, this should work, but it's not.

 

Thanks for any help

<telerik:GridDateTimeColumn HeaderText="Date/Time" UniqueName="APPOINTMENTDATETIME" DataField="APPOINTMENTDATETIME" ShowFilterIcon="false" DataType="System.DateTime" SortExpression="AppointmentDateTime" CurrentFilterFunction="GreaterThanOrEqualTo" AutoPostBackOnFilter="true" HeaderStyle-Width="125px" DataFormatString="{0:dd MMM yyyy hh:mm }" />

4 Answers, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 06 Apr 2016, 08:48 AM
Hi Rodney,

This issue is already resolved and it will be available in our next official release (R2 2016) and in our latest internal build.

Regards,
Kostadin
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Rodney
Top achievements
Rank 2
answered on 06 Apr 2016, 11:29 AM

Does that mean there is no workaround in the current release? We go live in 3 weeks.

Thanks

Rodney

0
Kostadin
Telerik team
answered on 07 Apr 2016, 01:10 PM
Hi Rodney,

I am afraid there isn't a workaround for this issue but you can use the latest internal build until the next official release.

Regards,
Kostadin
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Rodney
Top achievements
Rank 2
answered on 07 Apr 2016, 03:06 PM

Kostadin,

Thanks for the update. Normally I would try that but we are close to the release date to introduce a new Telerik release.

I'll be waiting for it though.

Rodney

Tags
Grid
Asked by
Rodney
Top achievements
Rank 2
Answers by
Kostadin
Telerik team
Rodney
Top achievements
Rank 2
Share this question
or