Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What would be the statement to only grab on a refresh today and only grab dispense dates of yesterday?
Where DispenseDt=today-1 as (DispenseDt);
This along should work:
Where DispenseDt = Today(1) - 1;
You are doing this in SQL, try this:
Where DispenseDt = SYSDATE - 1;