issue in using date_from_string in modify stage

[HemaV]

Hi All,

i tried using date_from_string function in Modify stage:
My o/p column is date datatype in oracle db.

In modify stage i used new filed DT
DT:date=date_from_string("2013-04-04","yyyy-mm-dd")

I'm getting this below error:
main_program: Error parsing modify adapter: Error in binding: Expected source field selector; got: ""2013-04-04""
Expected destination field selector, got: ")"; input:
DT:date=date_from_string("2013-04-04","yyyy-mm-dd")

Could you please let me know how to resolve this date issue?

Thanks in Advance,

[ray.wurlod]

The first argument of date_from_string must be the name of a column on the input link to the Modify stage. It cannot be a constant as you are trying to do.

Use an upstream Column Generator stage to generate the constant. Use a cycle with exactly one value.

[HemaV]

I'm using in job parameter the column p_dt which is of string datatype and value we pass through sequencer as "2013-04-04".

DT:date=date_from_string(#p_dt#,"yyyy-mm-dd")

Can't i pass it as job parameter?

[ray.wurlod]

The first argument of date_from_string must be the name of a column on the input link.

Not a constant.

Not a job parameter.

Not anything else.