Set a particular year calculation

[William Mead]

Hi, I am helping someone who is using Filemaker version 6 on a PC. She needs to have a field that is a calculation that results in the given year as of November 1st of any particular year.

For example, on Until Nov. 1, 2007, the field will have 2006 in it.

I thought I could set a calculation field that is:

If Nov 1, year, - but then I need it to do nothing if it is not nov. 1.

Any ideas?

[comment]

Try:

Year ( yourDate ) - ( Month ( yourDate ) < 11 )