This is a puzzler to me at the moment. How can I compare a field, which is a date, to the system date? I'm getting a data type mismatch error. If its a string to string comparison you just enclose the variable like so:
'" & variable & "'. I don't know how it is done with date data types. What does the quotes and '&' mean?