cancel
Showing results for 
Search instead for 
Did you mean: 

DateTrans Node Function Error when blank value(No Date) input to it

manemahesh
Participant
0 Kudos

Hi All,

In PO mapping we are using the below condition (screenshot MappingCondition) to do the transformation.

IssuedDate is input field with date format as (yyyy-MM-ddTHH:mm:SS) and we want it to be transformed to yyyyMMdd and pass to target field DT_EMIS.

We are having so many date values coming from Source field IssuedDate and when there is blank value for any of this input IssuedDate field our mapping gives exception as shown in screenshot(Error_HRInterface). It means our DateTrans function doesn't work when there is blank value (or no date value) coming into this function.

Please help how can we achieve this to transform blank IssuedDate to target field DT_EMIS(yyyyMMdd).error-hrinterface.jpgmappingcondition.jpg



Accepted Solutions (0)

Answers (1)

Answers (1)

Harish
Active Contributor
0 Kudos

Hi Mahesh,

The date trans should use with value and below mapping can help

input --> map with default (blank) --> Equals --> blank --> NOT --> If without else --> map input to date trans --> target

you can avoid the blank or missing field error with this mapping,

regards,

Harish