June 15, 200718 yr 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?
Create an account or sign in to comment