If, then with dates not working
I need to change some membership expiration dates in a database file. The current expirations dates range from 2004 to 2099. The calculation, If (Expiration Date > 1/1/2015; "12/31/2099"; "7/1/2013"), returns 12/31/2099 in every record. (Expiration Date is the current field.) Why is it not working?