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!

External Development Forums - SalesLogix OLEDB Provider
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Problem with dates off on CERTAIN datetime on activity fields

NixDev
Posts: 98

Problem with dates off on CERTAIN datetime on activity fields Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

RJ Samp
Posts: 973

Re: Problem with dates off on CERTAIN datetime on activity fields Your last visit to this thread was on 1/1/1970 12:00:00 AM

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.....

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/29/2024 4:08:27 AM