Access 2007 ACCESS IIF Formula to Select all values

E

emelendez80

Joined
Nov 19, 2009
Messages
1
Reaction score
0
Good afternoon,

I have the formula below and I'm trying to change it to give in all the values in this field minus 2008 (without actually putting 2008. this will change to wanting everything but 2009 next year and so on). The fasle statement right now gives me only 2007 but I need to change it to give me everything but current year -1. I tried to change this and everything so far has not work. Please any help would be great.

IIf(Month(Now())>=12,Right([Calendar Year],4),Right(Str(Year(Now())-2),4))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 1 vs 10 in Excel Formula 0
CONCATENATE text to create a formula to be evaluated 2
Fiscal YTD Filter 7
Obtain Month & Year from a Text formatted Date field using Left Fu 2
Add 0 before month 1 to 9? 7
Weird results (I think) for IIF 4
How to synchronize all cell values? 1
Using date to specify field name to use 1

Top