RE: [sqr-users] brain dead?

["Paul Hoyte" <paul.hoyte@sharidionne.com>]

Use the declare-variable command to declare those variables as dates then
move the values into them and then do the compare....you should be fine
after that.... 


Paul Hoyte
Sharidionne Inc.
(248) 752-6970
paul.hoyte@sharidionne.com
 

-----Original Message-----
From: sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org
[mailto:sqr-users-bounces+paul.hoyte=sharidionne.com@sqrug.org] On Behalf Of
Timm Buchanan
Sent: Wednesday, June 23, 2004 11:17 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] brain dead?

OK...I am using strtodate, and getting the exact same results....

Actual procedure:
begin-procedure report


let $date1 = strtodate('20031108', 'YYYYMMDD') let $date2 =
strtodate('20040108', 'YYYYMMDD') let $fromdate = strtodate('20040102',
'YYYYMMDD') let $thrudate = strtodate('20040116', 'YYYYMMDD')


display '$date1 'noline
display $date1
display '$date2 'noline
display $date2
display '$fromdate 'noline
display $fromdate
display '$thrudate 'noline
display $thrudate 


if $date1 >= $fromdate
        display 'date 1 >= fromdate'
end-if

if $date2 >= $fromdate
        display 'date 2 >= fromdate'
end-if

if $date1 <= $thrudate
        display 'date 1 <= thrudate'
end-if

if $date2 <= $thrudate
        display 'date 2 <= thrudate'
end-if

if $date1 <= $fromdate
        display 'date 1 <= fromdate'
end-if

if $date2 <= $fromdate
        display 'date 2 <= fromdate'
end-if

if $date1 >= $thrudate
        display 'date 1 >= thrudate'
end-if

if $date2 >= $thrudate
        display 'date 2 >= thrudate'
end-if


end-procedure



results:
$date1 08-NOV-2003
$date2 08-JAN-2004
$fromdate 02-JAN-2004
$thrudate 16-JAN-2004
date 1 >= fromdate
date 2 >= fromdate
date 1 <= thrudate
date 2 <= thrudate

_______________________________________________
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