is fin_dateRegFeePd a text field or a date field when you look at the field's definition in Manage | Database | Fields? Your description suggests that you've defined it as a text field.
Make sure that it's a date field, then rewrite your expression as:
If (fin_tuitionProtParticipation = "Yes" and fin_dateRegFeePd > getasdate("2/27/2009") ; 275 ; 0)
If (fin_tuitionProtParticipation = "Yes" and fin_dateRegFeePd > Date(2; 27; 2009) ; 275 ; 0)
date fields are really number fields that count the number of days since (0/0/0000) with special built in formatting to display in a month day year format. Enclosing text in quotes like you have won't be recognized as a date unless you use a function to convert it.
fin_dateRegFeePd is most definitely a date field.
I have tried it with and without quotes...without is just the latest version of the calculation. It does not seem to matter which I have in there, the result is the same.
I will try what you suggest and let you know. Thanks in advance for the help.
It worked. (Your second option of Date(2; 27; 2009.) Thanks for the help. Not sure WHY all my calculations all these years have worked without formating the calculation like that. This is the first year in at least 5 years that I have had a problem.
Getasdate("4/1/2009") should also work for you.
I've used FMP since it was version 2 and a flat file. As best I can remember, "4/4/2009" and 4/4/2009 do not evaluate as a date in a calculation expression for any version of filemaker pro. (The second options is interpreted as 4 divided by 4 divided by 2009 :smileywink: )