RE: [sqr-users] Date Calculations Help

["Tritt, Merrill" <MerrillTritt@spherion.com>]

One way to do this in DB2 is:

DATE(DAYS(CAST($ASOFDATE AS DATE)) - 7)
(Replace 7 with your variable.)

Alternatively,

$TargetDate > $ASOFDATE - 7 DAYS

should also work, but you may need to wrap a CAST around it.

Merrill


-----Original Message-----
From: Alexander, Steve [mailto:Steven.Alexander@sanjoseca.gov]
Sent: Tuesday, October 21, 2003 7:50 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] Date Calculations Help


I'm not sure about db2, but some databases would allow:

input #days 'How many days'

begin-select
...
from table t
where t.datefield between (sysdate - #days) and sysdate
end-select


-----Original Message-----
From: Deborah Harris [mailto:dharris@activeinterest.com]
Sent: Tuesday, October 21, 2003 4:26 PM
To: 'Sqr-Users Group'
Subject: [sqr-users] Date Calculations Help


Hi Everyone, 

 

I need to do some date calculations based on a value I receive from a
user.   They supply me with a number like 5.    I then need to calculate
5 days back from the current date and then do a selection of records
based on the current date and the new calculated date.     Does anyone
have some sample code on how I can do this?    

 

I am using SQR 8.1 and accessing a db2 database.  

 

Thanks in advance for any help.. 

 

 

 

_______________________________________________
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



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