Modify the 'Expires (MM/YYYY)' Format to MM/YY in a Transaction Saved Search Using a Formula

The Expires (MM/YYYY)  field is the credit card expiry date found on the Payment tab of a sales order, cash sales and payment forms (id=ccexpiredate). The default format is in MM/YYYY.  However, unlike other date fields, converting the format using the Formula Text = TO_CHAR({trandate},'MM/YY') will result to "ERROR: Invalid Expression". 

To avoid the error use Formula Text = CONCAT(SUBSTR({ccexpdate},1,3),SUBSTR({ccexpdate},8) ) instead