Create a Formula to Split the Month and Year Values Found in the CC Expiry Date Field into Two Columns in a Customer Saved Search

 

Make the following changes in the Customer Saved Search: 

1. Under Results tab > Standard subtab > choose the field Formula (Text) and under the Formula column, copy and paste the following formula for the 2 digit Month result:

to_char(to_date({ccexpdate}),'MM') 

2. Still under Results tab > Standard subtab > add another Formula (Text) field and under the Formula column, copy and paste the following formula for the 4 digit Year result:

            to_char(to_date({ccexpdate}),'YYYY') 

3. Add a Custom Label or Summary Label to the formula fields (Optional) 

4. Save and Run the search and check the result.