Hi all.

We have SLX LAN v7.2.1.

We have a table C_myTable that we import some data, one of which is an invoice date field from our ERP software. When I look at SalesLogix table it shows 07/22/2013, but when I look at the record in SalesLogix, it shows 07/21/2013.

What's going on? I'm importing the data via a SQL Server 2000 DTS.

Thank you in advance!

DTS doesn't take into account the actual UTC time. The provider looks at the date/time and converts it back to local time. You need to alter the colum in sectabledefs to set the DateTimeType to 'D' for this table/column. The SLX provider will then just report what is in the column without converting it to UTC.

So, assume the col is INVPAID then your SQL would be:

UPDATE SECTABLEDEFS SET DATETIMETYPE ='D' WHERE TABLENAME = 'C_MYTABLE' AND FIELDNAME = 'INVPAID'

Then restart the SLXServer (or, if you cannot do this then you can simply add DUMMYFIELD to any table, commit it, then drop it - this refreshes the server).

That fixed it. Thanks!