Can you post the exact formula you're using?

In article ,
"CheeseHeadTransplant"
wrote:

This seems to be working except for one small problem... it is giving the
results for the wrong day. It is always off 3 days. If I query 09/01/05 it
is giving the results for 09/04/05. I can't figure out why the strange
result.