Conversion error

[hargun]

hi,

i am getting error while converting string to date .

My job design

DB2 stage.........xfm............peek stage

the date field NEXT_PMT_DATE(VARCHAR(10) and i am using the following code

Code: Select all

If IsNull(select_stats.NEXT_PMT_DATE) then SetNull() 
Else If IsValidDate(StringToDate(select_stats.NEXT_PMT_DATE,"%yyyy-%mm-%dd")) then StringToDate(select_stats.NEXT_PMT_DATE,"%yyyy-%mm-%dd")
       Else SetNull()

the job getting aborted with below error

APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost

i tried by using the reject link and got NEXT_PMT_DATE:2013-02-30 in reject link since it is valid date i don't know why it is getting rejected.

Please help me on this.

[asorrell]

February 30th isn't a valid date. Not even on a leap year.

[ray.wurlod]

(What Andy said plus) not even if you're using a Microsoft operating system!