I've got a free-text field imported as Jan 04, 202...
# suiteanalytics
n
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?