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.

 

[mbarron]

Add parenthesis around your "do this stuff" of your If Then Else. The are in bold below.

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&quot)

Mike

 

[mbarron]

My first one was wrong. I had altered the formula differently than I posted. Sorry.
The following actually works.

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

 

[vbit]

Just what I needed. Thank you.

 

[alley211]

Here is another way to do this.

You can get the dateadd function from Crystal.

if x >month(CurrentDate)then dateadd("yyyy", -1, CurrentDate)
else date(year(CurrentDate), x, 01)

This will subtract the year correctly and use the previous year or use the current year when needed.

alley

 

[vbit]

I didn't think that DateAdd was available for Crystal 7.

Thanks.