bInvalidDateTime has value 1 - Empty Values

clmhwyfe · Post by **clmhwyfe** » Tue May 19, 2015 3:55 pm

Hi All,

Am using a derivation as show below for a TIMESTAMP field and getting the error bInvalidDateTime has value 1 because the Field164 is empty in some instance and the job is trying to insert a ' ' to the TIMESTAMP and aborts
If
IsNotNull(LNK_READ.Field164)
Then
StringtoTimeStamp((Trim(LNK_READ.Field164):' ':Trim(LNK_READ.Field165)),"%yyyy/%mm/%dd %hh:%nn:%ss")
Else
SetNull()

Am unable to use IsNotNull and TRIM(Field164) <> '' as am getting the error as shown in the below link.

http://www-01.ibm.com/support/docview.w ... wg21444564

Please guide me on the issue, I tried to trim the complete derivation but still couldn't remove the error

clmhwyfe · Post by **clmhwyfe** » Tue May 19, 2015 4:24 pm

Hi all,

I used the IsValidDate() instead of IsNotNull() and that resolved the issue.

Thanks All.