Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday.
Using Martin Gilbert's suggestion I get the current date & it works perfectly
CURDAT SUBSTR(CD, 1, 2) ||
SUBSTR(CD, 4, 2) ||
SUBSTR(CD, 7, 2)
Then use CURDAT in your selection
However I want to do the comparison to always include today & yesterdays data.