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;
Do check if DispenseDt date is only date or timestamp
Retrieving data ...