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

```WHERE
    master.id IN (
        SELECT DISTINCT tran.entity
        FROM transaction tran
        WHERE tran.trandate > CURRENT_DATE - 1
    )```
Adding this to my query gives this error

*Column:CURRENT_DATE not found.*

Any idea why?

```WHERE tran.trandate &gt; TO_DATE(CURRENT_DATE - 1)```
Like this?

Yes, sorry the -1 was on the next line and I missed that. TO_DATE(CURRENT_DATE - 1)

CURRENT_DATE works elsewhere in the query so not sure why it has a problem in this where

Hmm yeah I use CURRENT_DATE a lot, always in TO_DATE() but it also always works :thinking_face:

My dirty way of fixing this is to use a separate query to work out which customers have recent transactions (last 24 hours) then pass in a list of IDs to this larger query.

```WHERE
    master.id IN (CUSTOMER_ID_ARRAY)```


That's is a questionable workaround but it stops me having to mess with this massive query too much.