Skip navigation
Contact Us
956 Views 3 Replies Latest reply: Nov 7, 2012 1:38 AM by iliyas shaik RSS
David McLaughlin Novice 30 posts since
Aug 14, 2012
Currently Being Moderated

Nov 6, 2012 8:50 AM

How to use a port as variable in expression transformation

Hello Again,

 

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 Advise,

-David

More Like This

  • Retrieving data ...

Bookmarked By (0)