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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Time and Date display issue.....

Mario
Posts: 6

Time and Date display issue..... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Sep 07 2:13 PM

I am having an issue with my time and date. When i enter a new sale into SLX i have a not generator and a sales rep keeper that displayes every sales rep that has edited the order form. This is the problem when a new sale is created the correct time and dat are inserted into the database but when is display the information it is 4 hours behide, so say it's 2:00 pm the time will display 10:00 am. Can anyone help me with this problem. Have a problem with a datagrid displaying time that is 4 hours off, the time in sql is correct, I have recreated the data grid as well.

[Reply][Quote]

Ted Sturr
Posts: 78

Re: Time and Date display issue..... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Sep 07 4:54 PM

This is a GMT issue. Your program is not using the SLX OLEDB provider so it is writing the date into the table. SLX is looking at the record and using GMT to convert the datetime (that is why you have the 4 hour difference). here is a SQL statement sample you can run to fix tell the system not to do a GMT conversion on that field:

UPDATE sectabledefs SET datetimetype = 'D' WHERE fieldname = '
I think you might need to stop and start the SLXService for this update to "read" due to cacheing issues. But this should solve the problem moving forward. Your other alterntative is to use the SLXOLEDB provider for your create these records.

Ted

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/20/2025 10:40:11 AM