[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] brain dead?
- Subject: [sqr-users] brain dead?
- From: Timm Buchanan <timmbuck2@gmail.com>
- Date: Tue, 22 Jun 2004 16:04:51 -0600
- Delivery-date: Tue, 22 Jun 2004 17:06:43 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
OK, so spent the weekend in NYC for a Bachelor Party and probably
killed a few brain cells, but this is getting a little crazy. Please
help me prove my sanity....
begin-procedure report
let $date1 = '08-NOV-2003'
let $date2 = '08-JAN-2004'
let $fromdate = '01-JAN-2004'
let $thrudate = '31-JAN-2004'
end-procedure
In my mind:
$date1 is < $fromdate
$date2 is > $fromdate
$date2 is < $thrudate
However, running this procedure with some tests show this:
$date1 08-NOV-2003
$date2 08-JAN-2004
$fromdate 01-JAN-2004
$thrudate 31-JAN-2004
date 1 >= fromdate
date 2 >= fromdate
date 1 <= thrudate
date 2 <= thrudate
What am I missing? I have been writing SQR code for many years now...I
think I killed the SQR brain cells this weekend.....
Thanks...
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users