I know there have been posts about this several times. You can check the individual dateparts. I would do this, however:
sDate = DatePart("dd", Date) & "/" & DatePart("m", Date) & "/" & DatePart("yyyy", Date)
"WHERE ((([Next Due Date] = '" & sDate & "'"
I think that would work in spite of the data type issues.
HTH
mmcdonal
|