I think you need to use the DATEADD function or the TIMESTAMPADD function,
take a look at http://mesh-master:1972/csp/docbook/DocBook.UI.Page.cls? KEY=RSQL_timestampadd links to other date calculations are at the bottom of the page. whoops - this MAY only work in Cache 5+, just read that you are using Cache 4.1 - don't know whether its supported, if it is NOT, then consider the use of extrinsic functions to do the calculation within COS. kev
