Subtract CurrentDate year based on IF statement?

[vbit]

Usuing CR 7 with SQL database.

I am trying to create a formula that displays the previous year if certain conditions are true.
For example:

X is number field

if X > month(CurrentDate) then ["January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November",
"December"] [X] + " " + ToText((CurrentDate -1),"yyyy&quot
else
["January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November",
"December"] [X] + " " + ToText((CurrentDate),"yyyy&quot

The problem is that even though X is greater than month(CurrentDate) it still does not give me last year. It always shows the current year.

Thanks.

 

[kenhamady]

CurrentDate -1 subtracts one day, not one year.

Try Year(CurrentDate)-1 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[vbit]

Thank you.