I have a module that has the following IF statement that isn't working:
I'm trying to use this code to do the following:
If the difference in DAYS between rs("Date") and now is exactly 1 day (not counting for hours/minutes/seconds), I want to run that IF statement.
Please advise as to the best way to modify or re-create this code.
Thanks,
M
Code:
If DateDiff("d", Now(), rs("Date")) = 1 Then
...
End If
I'm trying to use this code to do the following:
If the difference in DAYS between rs("Date") and now is exactly 1 day (not counting for hours/minutes/seconds), I want to run that IF statement.
Please advise as to the best way to modify or re-create this code.
Thanks,
M