I'm trying to do a dcount if my date field is on or before today.
The date in [reminderdate] is 01/07/10. So i'm not sure why it isn't counting it.
if i change the date to 01/07/09 it works. i'm thing it is counting the date as a number? do i need to declare [reminderdate] as a date?
The date in [reminderdate] is 01/07/10. So i'm not sure why it isn't counting it.
if i change the date to 01/07/09 it works. i'm thing it is counting the date as a number? do i need to declare [reminderdate] as a date?
Code:
If DCount("[reminderdate]", "tbltasks", "[completed]<>-1 and [reminderDate]<= #" & Date & "#") > 0 Then
If MsgBox("You have tasks to be completed." & Chr(13) & Chr(13) & "Would you like to print a tasks list?", vbYesNo,) = vbYes Then
DoCmd.OpenReport "RptTasks", acNormal
End If
End If