3 Replies Latest reply on Aug 14, 2008 2:58 PM by casey.schmit

    Report Writer and UnDP

      Hi:


      I had created a couple of Reports based on SQL queries in Orion v8.x Report Writer and one field retrieved as part of the query was the DATE/TIME field from the CustomPollerStatus table.  Now since upgrading to Orion v9 these date/time values seem to be in GMT.  Is there a Format String that I can use in Report Writer's Field Formating tab to cause the time to be converted back to local time, or do I need to do some additional math within my SQL query first to convert it back to local time?  Please suggest a solution either way.


      Thanks.


      Dale