comparing date data types

[myetteski]

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?

[myetteski]

I got it already.
datefield = #" & variable & "# is how it should be.

You can also use each of those functions to emulate
other types. And for comparing a date field or a string
you can use CDate function.

CBool(expression)  - Boolean
CByte(expression)  - Bytes
CCur(expression)   - Currency
CDate(expression)  - Date
CDbl(expression)   - Double
CDec(expression)   - Decimaal
CInt(expression)   - Integer
CLng(expression)   - Long
CSng(expression)   - Single
CStr(expression)   - String
CVar(expression)   - Variant

-Kayoca Mortation