[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] brain dead?



Perhaps your program does not know that they are dates, but is comparing
them simply as strings?

Jon

-----Original Message-----
From: sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org
[mailto:sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org] On Behalf
Of Timm Buchanan
Sent: Tuesday, June 22, 2004 4:05 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] brain dead?

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

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