AnsweredAssumed Answered

If, then with dates not working

Question asked by UnionGuy on Apr 23, 2012
Latest reply on Apr 26, 2012 by Sorbsbuster

Title

If, then with dates not working

Post

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?

Outcomes