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: Selecting a date range in a grid

Robert Levine
Posts: 132

Selecting a date range in a grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jul 07 3:45 PM

I have a grid for which I create an SQL query at run time. As part of the query I'm attempting to test a range of dates. But to keep this question simple, let's limit the problem to just the format of the "WHERE" clause for the "STARTDATE" in the "ACTIVITY" table. When I use the follow test, I get an error:
[WHERE STARTDATE >= '07/20/2007']
The error message reads: "The conversion of a char data type to a datetime data type resulted in an out of range datetime value at line 195". I've tried all sorts of things like the workstation's Regional Settings for the short date. The actual date is in a variable and I've tried "FormateDateTime", CDate, etc. I've also tried using examples such as: '07/20/2007 00:00:00 AM'. Although a simple query in SQL Query Analyzer with the above WHERE clause works without any problems, when I try the same query in the SQL tool in the Slx Administrator program, it comes back with "Failed to parse SQL". Again the simple query was:
[SELECT * FROM SYSDBA.ACTIVITY WHERE STARTDATE = '07/20/2007']
Any ideas are most welcome.

[Reply][Quote]

Robert Levine
Posts: 132

Re: Selecting a date range in a grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jul 07 6:33 PM

I figured it out! What I needed was UTC Support. In the LAN Developer's Guide, I found that the OLE-DB level of the SalesLogix Server needs to have such dates placed into the following format:
[CCYYMMDD hh:mm:ss].

Once I formatted the test date into that format, my SQL statement worked correctly.

[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/19/2025 11:02:28 AM