Sage 200 UKI Ideas Portal
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.
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.
I always advise customers that X happened - plus or minus 1 hour as I am quoting the SQL data / time !