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