IIF Statement for Fiscal Year Isn't returning desired value

[PWil84]

Hello All,

I recently wrote the following Statement in Access: FY: IIf(Year([Date])<6,Year([Date])+1,Year([Date])) Right now it's returning the correct fiscal years for all of the dates that are less than 6. However, the fiscal years for the dates greater than 6 aren't changing. What would I need to add to that statement to fix the problem?

 

[Micron]

The problem isn't clear but some data and expected results from that data might help. You are not modifying the value of the reference if greater than 6 so you shouldn't expect any change? At least not from that expression.
FWIW, Date is a reserved word and should not be used for any object name.

 

[jackd]

@PWil84
I don't understand your requirement. Please rephrase your post and provide some examples to show your expected results.

 

[petertenthije]

Year([Date])<6,

This formula would return a year, right? As in: 2022, 2021, 2020…. but definitely not 6.