MVSFORUMS.com

[cappertan]

Hi:

After reading posts, I am still confused. I think I am close but do not have the syntax right. *** My goal is to find all date greater than that date + 84 days. Beg_dt are dates in my test database.

WHERE A.id = '1234'
AND A.RANGE IN ('V24.2', 'V72.31')
AND B.BEG_DT > ('2004-08-01' + 84 DAYS)

Eventually, in cobol/easytrieve I want replace that hardcoded date with a host variable (:INDATE).

Thanks for your suggestions.
_________________
Capp

[kolusu]

cappertan,

Try this