Fiscal Year Query problem

[boesch]

Here's my code for the fiscal year

Year([ValueDate])-IIf([ValueDate]<DateSerial(Year([ValueDate]),11,1),1,0)+1 AS FYear

No matter what date it reads from "ValueDate" it returns 1905
eg 11/01/2000 returns 1905
12/01/2003 returns 1905

When I click in the field of each record the date is displayed
11/01/2000 FYear displays 06/23/1905
12/01/2003 FYear displays 06/26/1905

Any ideas what I'm doing wrong?

 

[pbaldy]

I suspect it's returning the correct year, but being displayed as a date (if you understand how Access stores and displays dates, the numbers 2000 to 2003 would be those dates in 1905).

 

[boesch]

I changed the properties format to General Number instead of Date and that seems to have resolved the problem.

Thanks for the help!