Comparing dates

[LaurelLee]

I am attempting to write an if statement something like this:

If DLookup("FridayDate", "qryGetFridayDate")=Now() then
do something.

This is never evaluating to true because, as I see it, now() includes the date and time, and my field is a short date. So, I tried this:

If DLookup("FridayDate", "qryGetFridayDate")=CVDate(format(Now(), mm/dd/yyyy)) then
do something.

When this runs I get a runtime error simply stating "Overflow".


Any ideas on how I can accomplish this? Thanks!


___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha

 

[Blorf]

Instead of Now(), try just date

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[LaurelLee]

Yup, it is official, I need to go home.

Thanks!

___________________________________________________________
With your thoughts you create the world--Shakyamuni Buddha