Previous Year Date (1 Viewer)

[PBE]

Hi, Help would be appreciated.

Using CR 9 is there a function I can put in a formula which means it calculates the date a year before? For example, if todays date is 09/04/08, I want the formula to produce 09/04/07.

This is similar to a previous posting by Eany but I don't want to use CurrentDate-365 as this does not allow for Leap years.


Thanks

 

[Emmanuel]

Shouldn't you be able to use dateadd(yy,-1,getdate()) from the command section? Let me know if that works.