@aaz In NetSuite, date formats can affect how dates are displayed and processed, particularly when working with different subsidiaries that have different time zones or date formats. This could be the reason why the date is off by one day for one specific subsidiary. Here are some recommendations to handle this issue: 1. Use UTC time: When working with dates in scripts, it's a good practice to use UTC time. You can convert dates to UTC using the

nlapiDateToString

and

nlapiStringToDate

functions with the 'datetimetz' argument. This ensures that your dates are consistent across different time zones.

var dateInUTC = nlapiDateToString(new Date(), 'datetimetz');
var dateObj = nlapiStringToDate(dateInUTC, 'datetimetz');

2. Use date APIs: When working with dates, always use the appropriate NetSuite date APIs such as

nlapiAddDays

,

nlapiAddMonths

,

nlapiDateToString

, and

nlapiStringToDate

. These functions take care of the user's date preferences and time zone settings. 3. Check the time zone settings: Ensure that the time zone settings for the affected subsidiary are correct. Go to Setup > Company > Subsidiaries and edit the subsidiary. Check the 'Time Zone' field under the 'Address' subtab. 4. Check the date format settings: Ensure that the date format settings for the affected subsidiary are correct. Go to Setup > Company > Subsidiaries and edit the subsidiary. Check the 'Date Format' field under the 'Address' subtab.