Year() function not working

[Nick Booth]

I can't get the Year function to work.
Month and Day both work fine and code completion works with them but when I type Year( no code completion hint pops up. If I complete the function it always produces a run-time error such as type mismatch as if the year function did not exist.
Can anyone help, please?

 

[MHM]

Year(Date) should work (does with mine).

Did you try installing access again? Might be needed..

You might also use format('yyyy',Date).

 

[Pat Hartman]

This was a bug in A95 and possibly still exists in some places in newer versions. Use either the format() function suggested by MHM or the datepart() function.

 

[Nick Booth]

Thanks for the helpful suggestions folks.