I would troubleshoot this by testing subsets of the full expression one at a time via new calculations.
e.g, test the
'to_date([CLNDR_DT], 'YYYY-MM-DD') without the rest to narrow down where the problem is.
It's likely resolved by tweaking the syntax.------------------------------
Jason Tavoularis
------------------------------