Re: [sqr-users] brain dead?

[Don Mellen <donm@ontko.com>]

On Wed, 23 Jun 2004, Al H wrote:

> ...
> To further explain, SQR does not recognize dates at all.  
> ...

Incorrect.  SQR has recognized Dates since version 4.0

> ...
> But in SQR, the variable storing the date is a character variable, so
> it is evaluated under character rules.  
> ...

Again, incorrect for 4.0 thru 8.2 (the latest release).  

You do have to declare date variables; otherwise, they *will* be evaluated
as string variables since that is what they would be.

> On Wed, 23 Jun 2004 09:14:05 -0400, you wrote:
> 
> >As I recall, this is an old "feature" of SQR regarding the late day of
> >the month. There should be many archived postings.
> >
> >Basically, when you compare dates in SQR the last day of one month is
> >NOT less than the first of the next month
> >....

There was a problem with version 5 and one or two version 4 releases.
Since version 6.0, date comparisons have worked properly whenever I've
tested them.  I have not tested any of the "special" PeopleSoft SQR
versions, but the version PeopleSoft got was SQR 6.2 (for their
PeopleSoft 8.x), so when PeopleSoft got it, it was working.

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users