Setting the Timestamp Format
In SmarTeam - Web Editor, Timestamp fields contain the Greenwich Mean Time (GMT) data. When you insert this data, verify that you insert the GMT and not the local time. The following VB6 code is an example of how to retrieve both GMT and local time values:
Private Declare Sub GetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) Private Declare Sub GetLocalTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As Integer wDay As Integer wHour As Integer wMinute As Integer wSecond As Integer wMilliseconds As Integer End Type Public Function GetLocalDateTime() As Date Dim udtTime As SYSTEMTIME GetLocalTime udtTime GetLocalDateTime = DateSerial(udtTime.wYear, udtTime.wMonth, udtTime.wDay) + _ TimeSerial(udtTime.wHour, udtTime.wMinute, udtTime.wSecond) End Function Public Function GetSystemDateTime() As Date Dim udtTime As SYSTEMTIME GetSystemTime udtTime GetSystemDateTime = DateSerial(udtTime.wYear, udtTime.wMonth, udtTime.wDay) + _ TimeSerial(udtTime.wHour, udtTime.wMinute, udtTime.wSecond) End Function