4 Replies Latest reply on Apr 26, 2012 12:31 AM by Sorbsbuster

    If, then with dates not working

    UnionGuy

      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?