Crystal Reports: Date Formula 1

[Mags2010]

Hello:

I am currently using Crystal Reports 2008 & I am trying to find a formula that will provide me with yesterday's date 1 year ago. For example: If today is June 14, 2010 then I want to return the following date June 14, 2009. Does anyone have a solution they can share?

 

[lbass]

Did you mean "if today is June 15, 2010"?

dateadd("yyyy",-1,currentdate-1)

-LB

 

[Mags2010]

Yep that worked! Thanks so much!