Hi everyone, anyone experienced Transaction.status = 'B' is not working?

SELECT
	*
FROM
	Transaction
WHERE
	( Transaction.createddate between TO_DATE('2024-02-21', 'YYYY-MM-DD') AND TO_DATE('2024-02-23', 'YYYY-MM-DD'))
AND ( Transaction.status = 'B' )

Try using the specific filter as shown in this Zig article: https://blog.prolecto.com/2013/08/30/netsuite-searchfilter-transaction-internal-status-list/

You can try wrapping the condition in builtin.df(status) and compare on the text version

I apperciate @Clay Roper and @SimonC. You guys save my time!