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.