ToText formula returns "Bad Number Format String" error 1

[marlow1208]

I am using the following formula and get a "Bad Number Format String" error:

If month(currentdate) = 1
then ToText((year(currentdate)- 1),"yyyy")
else ToText(year(currentdate),"yyyy")

If I remove the formatting argument on the second line of code as the following, it works:

If month(currentdate) = 1
then ToText(year(currentdate)- 1)
else ToText(year(currentdate),"yyyy")

I need the formatting argument included. Can anyone tell me what I am doing wrong?

 

[davisprogrammer]

Are you just trying to remove the comma from the year? If so, try this:

ToText (Year(currentdate-1),0, "")

 

[marlow1208]

That worked just as I needed it to. Thank you very much!

 

[lbass]

The problem with your original formula was that you were using date formatting on a number (year). You could also have used:

If month(currentdate) = 1
then ToText(year(currentdate)- 1,"0000")
else ToText(year(currentdate),"0000")

-LB