Subtracting time from years?

[Yustrn]

I have a report I'm creating in Crystal 10

So what I have is a purchase date and a purchase period

Purchase date would be like 8/14/2007 and the purchase period would be like 1 or 2 or 3 or 4. What I need is a formula that would subtract 1 year from the purchase date if the purchase period is 1 example


Purchase Date - Purchase Period, but how do I tell it if purchase period is 1 remove 1 year from the Purchase Date and if it is 4 years then remove for years etc?

All help is appreciated.

Thank You

 

[synapsevampire]

Try:

dateadd("yyyy",-{table.period},{table.date})

-k