Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Database
Created by Guest
Created on Apr 24, 2017

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.