Get item changed on ItemDataBound to export correctly

1 posts, 0 answers
  1. Jeff
    Jeff avatar
    46 posts
    Member since:
    Jan 2008

    Posted 23 Dec 2017 Link to this post

    We've got a UTC time coming from the database and being assigned to a GridDateTimeColumn in a Grid. We change the time to local time on the ItemDataBound. That all works great. The challenge we have is that when we use the built-in export to Excel, the column reverts back to UTC time. After many hours of searching online and in the forums and trying everything from trying to re-change the value i the ItemCommand, the ExcelMLWorkBookCreated, the ExcelMLExportRowCreated, the prerender and everywhere else we could think of, we're stumped. We can change other items stylistically with those functions but we can't figure out a way to get the DateTime to either export as it is displayed in the grid (local time) or to re-convert it to local time for the export.
Back to Top