Quote Originally Posted by Rick Rothstein View Post
I think your problem is you did not inverse the arguments when you used TODAY()-1... if you look at the header for the function, namely...
Well, I really don't have to. I could just switch TODAY() - 1 to TODAY() + 1 to get an inverse because TODAY() - (TODAY() - 1) = (TODAY() + 1) - TODAY(). That's what I did, but I still got the #VALUE error.

Quote Originally Posted by Rick Rothstein View Post
As the name implies, it raises an error, to be exact, it raises the "Invalid procedure call or argument" error (it is how the program communicates to the outside world that something is wrong with one or more of the arguments to the function when, in fact, something is actually wrong with the argument that has been passed into the function.
Is there a VBA Doc place like the JavaDocs on Oracle's website where I could go look up that object? I would like to know more.