3 Replies Latest reply on Dec 4, 2015 2:19 PM by TKnTexas

    Date comparison results

    TKnTexas

      I wanted to display a message on a customer account, if their credit card was expired.  I thought it was a simple comparison of the Expiration Date to the Current Date.  But I did not get the results I anticipated. 

       

      I added a Current Date field (just the simple calculation of "Get (Current Date)", for a visual.  The expiration date was stored as a text field mm/yyyy.  I converted it to a date, pushing it to the first day of the month after.  FileMakerExample.png

      FileMakerExample2.png