SuiteQL. I need to select all order for a specific date. I'm using WHERE type = 'SalesOrd' and trandate = '2020-12-14' It's not working. What is the "trick" to specifiy a date

You need to convert that string into an oracle db date most likely https://www.abaci-us.com/netsuite-to-date-to-char-date-functions/

Works perfectly. Thanks

you should be able to use a raw string but it needs to be in the correct format. That said I'd recommend being explicit about date with format as shown above as a safer route.