I appreciate all your help!
Now I have an expression transformation which has an input IN_SCHED_DATE, then an interrim_ESTIMATED_DATE, and an output of OUT_ESTIMATED_DATE_ID. So I want to do some initial calculations off of IN_SCHED_DATE for the interim_ESTIMATED_DATE. Then I want to access the interrim_ESTIMATED_DATE in the expression of OUT_ESTIMATED_DATE_ID.
I am trying to use
TO_INTEGER( TO_CHAR(TO_DATE( interim_ESTIMATED_DATE, 'DD-MON-YY'), 'yyyymmdd') )
but the validation always complains about the interim_ESTIMATED_DATE invalid operand to TO_DATE.
Please check the datatype of interim_ESTIMATED_DATE is string. If it is a string, then check whether the format matches with 'DD-MON-YY'
Might be a datatype mismatch between the fields....
check the column is compatible
Check the datatype, Might be the issue is because of datatype mismatch