Saturday, December 21, 2013

Crystal: making sense of the AUDTDATE and AUDTTIME fields

Each Sage 300 ERP table has an AUDTDATE and AUDTTIME field, these store the date and time a record was last modified in the database. The date and time is stored in UTC time and needs to be converted to your local time zone to make sense.

Here is an example of a Crystal Reports formula to convert to your local time zone taken from your computer's OS settings:

ShiftDateTime (pwformatdate({GLPOST.AUDTDATE})+pwformattime({GLPOST.AUDTTIME}),"STD,0" ,"" )

No comments:

Post a Comment