When processing date values, getting year or month may result in a 'NaN' error.

Document created by anton_serbanescu Employee on Mar 22, 2017Last modified by chris_stevens on Apr 28, 2017
Version 2Show Document
  • View in full screen mode

Issue

For example, you have the following process:

 

The message shape has the following data:

<date1>2017-01-21</date1>

 

When you run the process, you end up with the following error:

 

 

Solution

Check the map and the map functions. Make sure the data types matches between the source/inbound profile and the inputs to the map function.

 

In this case, the map function input(s) had the data type set to character. Changed to Date/Time and the process executed successfully.

 

Map Function inputs data types:

 

Source profile elements data types:

 

Once the above change is made, rerunning the process results in a successful execution, all while pulling the correct values.

Attachments

    Outcomes