Date Formatting issue from EDI data

B2B Manager for EDI
1

I’m creating an import step from AS2 850 document to NetSuite Sales Order. I’m running into an error with the date field where it is not liking the format that is being transformed from the AS2 data.

In the AS2 data the date is formatted as YYYYMMDD (20260109)

In the mapping output the date is formatted to MM/DD/YYYY HH:mm:ssA (1/9/2026 12:00:00 am)

No matter how I change the date format in the settings the output does not change. I’ve tried a handlebar expression to manually format and what works on the same data in sandbox, throws an error in the mapping saying the value is wrong for the format even though they are the same.

Any ideas on what’s causing this or how to fix it?

2

@jackhansen can you please share an image for my reference?

3

Here is the input/output preview results:

image
image457×566 44.8 KB

Current Mapping:

image

Mapping settings with random date format for seeing if it changed anything:

image
image758×583 26.4 KB

4

Hi Jack,

When using NetSuite imports, in the Date Format field you are supposed to fill in the date format of the Source data.

So in your case you would fill ‘YYYYMMDD‘ as the format. Integator will then use that to convert 20260109 to NetSuites date format (it already knows what format NetSuite uses so no need to specify that.)