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