Is it possible you created your date field as text type accidentally?
Your calculation as written will return Zero only on Charter when the Date is 1/1/2012 OR GREATER.
less < more
more > less
You have the wrong operator in the calc as posted for the result you want.
Or am I confused by your post?
What calc is returning the wrong value? That's the one which needs troubleshooting.
This is a case of Apples v Oranges!
Your calculation compares 'Date' with '12/31/11' - as far as FileMaker is concerned, one item is a Date, the other is 12 ÷ 31÷11 - Not surprising that you get the wrong answer.
Try 'Date < Date(12;31;2011)' This should work.
Best wishes - Alan Stirling - London UK
No you are correct it was responding the opposite of how it was typed. However Alan's post is the correct method for this. I just wasn't thinking. Thanks, Paul
That's the ticket, I just was not thinking about the Date function.