Sage 200 UKI Ideas Portal

User correct DateTimeCreated in the database!!!

We create a number of reports in Sage based on data directly from SQL. We use the DateTimeCreated field in a number of tables to provide KPIs and time triggered reports. DateTimeCreated has always been generated from the Server time that SQL is running on, but for some reason, this has now changed to UTC. This means that for 1/2 of the year all DateTimeCreated figures are incorrect in our database by 1 hour. Please can this back so that the DateTimeCreated fields are correct.

  • Guest
  • Apr 24 2017
  • Idea Accepted - Gauging Support