days_since_from_date

[hhh]

Hi All,

Have requirement of to get number of days between two dates, have used date format as yyyy-mm-dd in DaysSinceFromDate function . While running datastage job , getting few warnings like : "DW_AcctArrg_Tfm1,4: Conversion error calling conversion routine days_since_from_date data may have been lost" .

I have checked that date value is yyyy-mm-dd only despite getting above message. Length is given int 32 in stage variable. This stage variable is being used in calculation of other fields.

Could you please guide on same to eliminate such problem. :(

Thanks in advanced

[ray.wurlod]

Have you really got dates, or strings? If you've really got dates, why are you specifying a format string, and where?
If you have strings, check your data for any date that does not conform to your specified format (for example, a single digit day or month number).

[chulett]

Post samples of your date data and the actual derivation you are using.