Excel Export of DateTime Value Not Exporting Time

5 posts, 0 answers
  1. Rodney
    Rodney avatar
    40 posts
    Member since:
    Mar 2015

    Posted 01 Apr Link to this post

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

  2. Kostadin
    Admin
    Kostadin avatar
    1713 posts

    Posted 06 Apr Link to this post

    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Rodney
    Rodney avatar
    40 posts
    Member since:
    Mar 2015

    Posted 06 Apr in reply to Kostadin Link to this post

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

    Thanks

    Rodney

  5. Kostadin
    Admin
    Kostadin avatar
    1713 posts

    Posted 07 Apr Link to this post

    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.
  6. Rodney
    Rodney avatar
    40 posts
    Member since:
    Mar 2015

    Posted 07 Apr in reply to Kostadin Link to this post

    Kostadin,

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

    I'll be waiting for it though.

    Rodney

Back to Top
UI for ASP.NET Ajax is Ready for VS 2017