Time that appears in the date/time column of datagrid is incorrect

[SLX_User]

Hi all.

One of our datagrids is not showing the correct time in the date/time column. For example, the date/time value in the table is: 4/23/2009 11:58:31 AM, but in the datagrid it shows: 4/23/2009 7:58:31 AM

The table is updated with the time via a DTS using the GetDate() function.

We are on SalesLogix Client LAN v7.2.1

Why is it showing a different time than what is in the table?

Thank you in advance!

[MikeSpragg · Accepted solution]

It's because of TimeZone - SLX applies the time-zone to the client - but the time is always stored in UTC format. You should use GetUTCDate instead.

[SLX_User]

Thanks that worked!