Hey all, working on a text to date conversion in a Saved Search. Using a text field (fieldid), this isn’t the actual field id i’m using. Either way, I am getting invalid expression. Wondering if anyone know’s why this wouldn’t work. TIA

• have you tried entering the actual string date? example TO_DATE(’11/11/1111′,’MM/DD/YYYY’)

That works but not when using the field I want to merge in

can you share your column {fieldId} data tnx

@TMann I tried every variation I could and didn’t work. I ended up writing a script