Realtime External Table Date Format mm/dd/yyyy

We successfully define Realtime tables against JDE tables, using the data service option.

In one case I am bring back Date data.

The format on JDE is mm/dd/yyyy

On Nextworld it fails for dates where the day is > 12. Shows a result of Invalid data. For days where the day is less than <13 it shows the date. I included some view from Nextworld and the equivalent in JDE data, and also the Connector mappings and Dataitem definition. Is this the expected behaviour? Is there a way around this?

Anyone else see something similar?

@cheyanne.schwiethale @chris.walsh Is there a specific way to setup these?

This looks like a bug. Can you please work with your system administrator to submit a ticket for this issue?