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.
StringtoDate() convertion in PX
Moderators: chulett, rschirm, roy
Wrong forum
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!
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!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"