3/18/2026 8:43:17 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Problem with dates off on CERTAIN datetime on activity fields
Posted: 13 Jul 10 7:05 PM
|
Hi all.
I'm running a .net app that moves data to activity table. All of the datetime fields show a 4 hour offset from what I see on the DB via SQL Server and what I see using OLE-DB Driver. That's fine. The problem is that startdate and originaldate DO NOT show this 4 hour offset. Needless to say, all datetimes are treated equally on my insert statements and ADO parameters. I tried with DateStamp type parameters and straight strings formatted using "yyyyMMdd HH:mm:ss" format string. The problem remains. One strange thing that I noticed is that both those fields show only date when queried using ADO Explorer, even though they are supposedly date/time according to SalesLogix DB Administrator (the other date/time fields show date and time correctly).
What could be the cause of this?
Thanks |
|
|
|
Re: Problem with dates off on CERTAIN datetime on activity fields
Posted: 22 Jul 10 11:34 AM
|
Look at the DateTimeType field in SECTABLEDEFS for how the SLX OLE DB Provider will handle that field. It's not always offset for you going through the provider.....
Every Date is DateTime in SQL Server and SLX.....it's how it is handled during storage and display that's the ticket....
Welcome to 'Z' dates.....
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|