I have a date field.

I have a calculation field that says,

If (date > "7/15/2002", "Y", "N")

For some reason, all dates in the date field evaluate to Y.

If I change the calc to

If (date = 7/15/2002, "Y", "N"), everything evaluates to N, even if I enter 7/15/2002

Is this not a valid calculation?

Thanks.

M.

If (yourDate > Date (7,15,2002), "Y", "N") would be a good way to do it. Are you sure you need the "N" to be there? It's generally more useful to only return a result when true. It simplifies the calc too:

yourDate > Date (7,15,2002)

...is all you need. The result will be "1" if true.

Make sure yourDate is a Date and not a Text field.

the date field is definitely a date field.

myDate > Date(7,15,2002) is the answer.

As far as returning the N, the actual calculation does something else. This was just my simple test calculation to work on that formula.

Thanks for the help.

M.

Thanks from me too. Your solution solved a somewhat more complicated problem I just posted (Case function nested inside an If function) before I looked at your answer.