How do you store SalesLogix data in the local time format???


We are currently working on SLX v 6.2.5, when we stored data in a table, it appears SalesLogix oledb provider stored it in GMT format. Is there any way to store data in local time format?


SQL Server does the storing. It’s in datetime,not GMT, format. The VALUE is GMT. The provider converts it back to local time.

As long as you access the Data via the SLX OLEDB Provider, it will be returned on your Local Time Zone.

Otherwise, you just need to be aware of the Time difference and convert the values as necessary.

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) news and product updates!

You have Successfully Subscribed!