Hi guys, I need some suiteql help. The following query returns the item I am looking for

SELECT item.createddate FROM item where item.id = '2328'

But this one doesn't

SELECT item.id FROM item where item.createddate = '12/31/2021'

Can someone help me what could be wrong with this item?

Try

TO_DATE('12/31/2021','MM/DD/YYYY')

Thanks. It worked SELECT item.id FROM item where TO_CHAR(item.createddate, 'MM/DD/YYYY') = '12/31/2021'

createddate is probably a timestamp