SalesLogix web client- grid showing date in UTC instead of converted to local time

I recently ran into an issue where a gird in the SalesLogix web client was displaying a date time field as one of the columns.  The date time that was showing was showing the UTC equivalent date (as it is stored in the database). The date was not being converted to the local time as it was displayed. 

 

It turns out the issue was the date field was added to the grid as a BoundField column instead of a DateTime column.  Apparently using the BoundField column the system will not convert the date to local time.  Switching the column type caused the dates to start showing as the correct local time.

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!