Re: how to report problems with Quantum DB plug-in?

["Richard Schoen" <richard@xxxxxxxxxxx>]

Thanks for the clarification. 

I guess that is where we've seen problems when we've tried to convert
from *ISO to MM/DD/YY. 

I use Quantum all the time and it's a nice SQL tool.  

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT

*******Effective August 1, 2008
New Phone: 952.736.5800
New Fax: 952.736.5801
Other numbers are unchanged

-----Original Message-----
------------------------------

message: 6
date: Thu, 31 Jul 2008 14:06:57 +0000
from: "Dave Shaw" <daveshaw@xxxxxxxxxxxxx>
subject: Re: [WDSCI-L] how to report problems with Quantum DB plug-in?

Richard,

I believe that *ISO supports dates from '0001-01-01' to '9999-12-31'.
*MDY only supports '01/01/40' (1940) to '12/31/39' (2039).  I believe
that Michael is correct that his problem is due to Quantum defaulting to
*MDY, and I hope that the suggestions others have made about adding an
explicit date format command to the connect string fix his problem.

Note that if *ISO didn't support dates before 1/1/40, Michael wouldn't
have been able to put them in the database in the first place.

Dave Shaw
Mohawk Industries