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

<@UN8UBEXK2> keep in mind what <@U856E2SEA> said yesterday about TranDate also including time, so you may want to modify your WHERE clause to be more like:

```         TranDate &gt;= TRUNC(SYSDATE)
         AND
         TranDate &lt; TRUNC(SYSDATE + 1)```