Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this 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.

  • Andrew Dunn
    Feb 6, 2025

    I always advise customers that X happened - plus or minus 1 hour as I am quoting the SQL data / time !