I've got a free-text field imported as Jan 04, 2022. In a saved search the
formula(date) = TO_DATE('Jan 04, 2022','Mon dd, yyyy') returns 04/01/2022 as expected.
If I change to the source field name
formula(date) = TO_DATE({custrecord_date},'Mon dd, yyyy') returns ERROR: Invalid Expression
any insights?