DSXchange

my doubt is on StringtoDate() convertion .......................

My input date is 1052003(dmmyyyy).I am getting this field as a varchar field(length 7).

I want to convert this into date field(yyyy-mm-dd)

In transformer i am using the function StringToDate()

I assume StringToDate() takes only the exact date format(ie if i get the input field as 01-05-2003 then i can use the function stringtodate())
Its perfectly working fine.

My input is 1052003(dmmyyyy).So i am splitting the input value as
d in one stage variable,mm in one stage variable,yyyy in one stage varibale.

and concatenating all the three as below
Year:'-':Month:'-':Day

When i try to load this in oracle(10g) i am getting the following warning.

INSERT_AR,0: Invalid date value in getInputFieldAsDate() for field '10' of input dataset '0'.

I am assuming that the problem is with the format because i tested with a hardcoded date(2003-12-01) into the table its getting properly inserted.

Kindly let me know where i am going wrong.
Any inputs would be appreciated.

Regards,
Siva.

Have you tried StringToDate(InpuField,"%d%mm%yyyy") without any delimiter.
(But May I know how you to express all dates with single digit?)

Hi Siva,

If kumar's suggestion doesn't take care of your need, you might try asking in the parallel forum so you get your question in front of more people using your version of the tool.

Bestest!