Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Never mind... got itSuiteQL where date =
I am trying to use date in the where clause below. It returns a lot of records that don't match
I have tried many variations
This works
"where p.startdate <= TO_DATE('" + mydate + "','MM/DD/YYYY' )" +
" and p.enddate >= TO_DATE('" + mydate + "','MM/DD/YYYY' )";
Tagged:
0