Hi,
thanks all.
My Isvalid function are:
Isvalid("date","20":link.field[1,2]:"-":link.field[3,2]:"-":link.field[5,2])
[]'s
Search found 3 matches
- Thu Jan 28, 2010 3:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion warning
- Replies: 8
- Views: 4169
- Tue Jan 26, 2010 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion warning
- Replies: 8
- Views: 4169
- Mon Jan 25, 2010 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion warning
- Replies: 8
- Views: 4169
Re: Date conversion warning
hi,
using StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"2000%yy%mm%dd") works. But, the warning appears if the field has some invalid value. Example: "AA1253".
using StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"2000%yy%mm%dd") works. But, the warning appears if the field has some invalid value. Example: "AA1253".