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

    Date comparison results


      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