[Solved] Excel Export of DateTime Value Not Exporting Time

[Rodney]

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 }" />

[Kostadin]

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

[Rodney]

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

Thanks

Rodney

[Kostadin]

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

[Rodney]

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