Crystal 8.5: Ending Date Last Year Problem 1

[goopit]

Hello,

With the formula below, I am having trouble getting the correct date to show.

For instance, say the Ending Date for the current year range is 02/01/06. Using this formula, I get an Ending Date for the same range last year as 02/28/05. I would like it to return 02/01/05 instead.

SAME-RANGE-LY-END-DATE

IF Month({?Ending Date}) <> 12
then Date (Year ({?Ending Date})-1, Month ({?Ending Date})+1,-1)-1
Else Date (Year ({?Ending Date})-1, 12,31)


Any help will be greatly appreciated.

Thanks,

Scott

 

[lbass]

You should be able to use just:

dateadd("yyyy",-1,{?enddate})

-LB

 

[goopit]

LB,

Thank you for very much for the prompt and accurate response.

Scott