Last Updated Time Stamp in Sage 300

The last updated datetime stamp for every record in Sage 300 is stored in two fields AUDTDATE and AUDTTIME and from the forum I've learned that AUDTTIME is in GMT time. From my own testing it seems AUDTDATE is also part of the GMT datetime format meaning if it is now 04/17/2015 at 6:49PM PDT when I update a customer record then the value of AUDTDATE will be 20150418 and AUDTTIME will be 1491948  (GMT-7).

Is there a function or code to use to translate the Last updated DateTime in local time?

This is for Sage 300 v2014 / SQL Server 2008 R2 Database.

Thanks in advance for the help.

Parents Reply Children
No Data