x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 4 replies
  • Subscribers 92 subscribers
  • Views 4415 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
758
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
410
replies
J-Y

Last Updated Time Stamp in Sage 300

Posted By

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
  • 0

    Google it, there are many references for converting UCT or GMT to local time.

  • 0 in reply to Ettienne Schwagele

    Thanks for the reply Ettienne. My previous searches so far always point me to SQL functions and other programing language coding that are beyond my understanding. I was wondering the approach Sage uses to translate to local format and hoping there would be an easier way to display the local datetime in a simple SQL Select statement without the use of SQL function and complex coding.

    At the beginning I was thinking about simply deducting the hours from AUDTTIME before I realized I had to deal with the date as well. Maybe concatenate the two fields and use Dateadd() in my Select statement???

Reply
  • 0 in reply to Ettienne Schwagele

    Thanks for the reply Ettienne. My previous searches so far always point me to SQL functions and other programing language coding that are beyond my understanding. I was wondering the approach Sage uses to translate to local format and hoping there would be an easier way to display the local datetime in a simple SQL Select statement without the use of SQL function and complex coding.

    At the beginning I was thinking about simply deducting the hours from AUDTTIME before I realized I had to deal with the date as well. Maybe concatenate the two fields and use Dateadd() in my Select statement???

Children

*Community Hub is the new name for Sage City