TKnTexas

Date comparison results

Discussion created by TKnTexas on Dec 4, 2015
Latest reply on Dec 4, 2015 by 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

Outcomes