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