This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, does anyone here know in Boomi how to get the date to remain the same thats being passed in?  The date format is off by a day when its mapped

Is it off by a day, or is it just a timezone thing? That’s what I would recommend you check.

the timezone looks to be set normally on the integration user account

if it's a straight mapping from one system to another then yes this is likely a timezone issue. If you're using a groovy script for date arithmetic of some kind then there is a bug in the implementation (possibly similar to the bug in Excel relating to the "leap year" in 1900) I don't have access to my boomi account any more but I think you can reliably adjust by the 1 day

that's what I was doing in my script anyway, and I never had any issues

I would check the timeline in NS and Boomi. They should be the same this happens with Celigo 

thanks Jon!  I tried setting the format of the time and that seemed to fix the issue

I sent about five sales orders into our sandbox environment