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

We have a sales report that will run either Sunday night or Monday morning to get last week's sales Monday-Saturday (inclusive ), which is better
```WHERE
      t.type IN ('CustInvc', 'CashSale')
      AND t.trandate >= TRUNC(CURRENT_DATE, 'IW')
      AND t.trandate <= TRUNC(CURRENT_DATE, 'IW') + 5
-------------------------------------------------------------------------------
      AND t.trandate >= TRUNC(CURRENT_DATE, 'IW') - 7
      AND t.trandate <= TRUNC(CURRENT_DATE, 'IW') - 2
-------------------------------------------------------------
AND t.trandate >= TRUNC(CURRENT_DATE) - 7
AND t.trandate <= TRUNC(CURRENT_DATE) - 1```

i am setting the script to run sunday night at 9pm will netsuite treat that as sunday or monday  we are on est ?