how to subtract 1 year from given date 1

[namas]

environment: CR 8.5

How to subtract a year from a given date range?

eg. date range is: 04/01/2006-03/31/2007

I'd like to get a date value prior to 04/01/2006 (subtract 1 yr from
mimimum of range value) which would be 04/01/2005.

Date is a parameter field ({?Pm-?Fiscal Year}) that accepts range values.


Thanks

 

[synapsevampire]

You don't explain the context in which you need this, so here's how to filter:

Try:

(
dateadd("yyyy",-1,minimum({?MyDateParameter})
and
dateadd("yyyy",-1,maximum({?MyDateParameter})
)

-k