Re: SQR Bugs

["Beller, Jay" <jbeller@LBISOFTWARE.COM>]

This is a known bug - it's not just August/Sept 2001, but EVERY month
end/month start. When you compare date 1 to date 2, SQR sees them as being
the same date.

The workaround is to avoid comparing the 2 dates as date fields. Instead,
convert each to YYYYMMDD format strings and then compare the strings.

-----Original Message-----
From: Jason Sekkes (SB) [mailto:Jason.Sekkes@STROEHMANN.COM]
Sent: Wednesday, September 05, 2001 2:53 PM
To: SQR-USERS@list.iex.net
Subject: SQR Bugs


I am wondering if there are any known bugs in SQR 4.3.4 concerning dates (
We are using Oracle and running in a Windows environment).  On the change of
the month SQR is lumping data with the date of August 31,2001 with data with
date of September 1,2001, which is throwing all of our calculations off.
Any help would be appreciated.   Thank you.


Jason