problem with function Now()

S

Shiller

Experts,

I'm trying to add 14 days to the Now() function in a query but it's
not working. I try using it in conjunction with DateAdd function with
no success.

Please help!
 
J

Jeff Boyce

"Not working" isn't very descriptive.

What is happening?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

It helps other to make suggestions if you give more information than 'but
it's not working.' What are your results? What is your exact SQL
statement that you are trying? Give examples of data input and output.
 
S

Shiller

"Not working" isn't very descriptive.

What is happening?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

When I run the query with "Now() + 14" as the criteria I get nothing
back eventhough I have data in my table that matches that criteria.
 
G

George Nicholson

When I run the query with "Now() + 14" as the criteria I get nothing
back eventhough I have data in my table that matches that criteria.
Click to expand...

You sure about that?

Now() includes a Date *And* Time value. When you say you have data that
matches that criteria, it would have to match the hh:mm:ss as well as the
date, so it entirely possible that you don't have any matches. Actually, the
stored value is more precise that hh:mm:ss, so its even less likely you have
a match.

If the field you are trying to match only contains a Date value then you
probably want:
Date()+14
If the field you are trying to match contains Date and Time, but you only
want to match the Date portion then:
DateValue([MyDateTimeField]) with Criteria of Date()+14
 
Top