StingtoDate

[devanars]

I am getting this error while converting stringtodate. source is .csv file and datatype is varchar have to keep date in oracle target.
using the ds version 8.1

I am using the code: StringToDate(SRC.DATE,'%mm/%dd/%yyyy')
getting resulet like **************

APT_CombinedOperatorController,0: Data string '11/2/2007' does not match format '%mm/%dd/%yyyy': the value for tag %dd has fewer characters than expected.

any advise!

[ArndW]

I had that issue a while back and had to use the length and an IF THEN ELSE clause with two different pictures for the date. I vaguely recall having seen someone post a format that accepts variable length date components but am not sure - I do know that it isn't documented.

[betterthanever]

using this format would solve the issue

Code: Select all

StringToDate(SRC.DATE,'%m/%d/%yyyy')

[betterthanever]

repost

[betterthanever]

using this format would solve the issue

Code: Select all

StringToDate(SRC.DATE,'%m/%d/%yyyy')

[devanars]

what is the format i can use if i need to keep the date like 19 sep 2008.

[chulett]

What do you mean 'keep the date'? A date is a date and is stored in an internal representation, only external (string) formats have display options like that. So use whatever mask matches the incoming date format in the StringToDate function.