Zika Raj 16.Nov.15 03:12 AM a Web browser GeneralAll ReleasesAll Platforms
I am trying to do export from lotus notes base to oracle table.
I have problem with converting data during the process. I have lotus data field which is type date, and field in oracle table that is of type text.
When using this formula in connection document for data transformation i am getting error:
Error: Field type mismatch: 'Planirani početak' Source Connector field is type Datetime, Target Connector field is type Text,
formula that i use for data transformation:
FIELD PlanPoc := @If(PlanPoc = ""; "(no data)";@text(PlanPoc));
---PlanPoc is field in lotus notes document, that is of date/time type