Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 72
Registered: ‎04-01-2009
Accepted Solution

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

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!

Highlighted
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

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

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.
Copper Elite Contributor
Posts: 72
Registered: ‎04-01-2009

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

Thanks that worked!