Problem with date query

[mulisha07]

I have a date field which has a default value of =Now() so that the user does not have to input this value during data entry. However, when I do a query for this date field, it does not show any of the data related to the date. One thing is, if I enter the date field manually, the query works with the date field entered.

Can anyone help out with this problem? Thanks in advanced!

 

[John Big Booty]

Try using Date() rather than Now(). Date() will return the current date. Whilst Now() returns the current time (HH:MM:SS) as well as the current date, so unless you really need the current time, avoid using Now() as it will only complicate thing as you have found out.

 

[mulisha07]

Try using Date() rather than Now(). Date() will return the current date. Whilst Now() returns the current time (HH:MM:SS) as well as the current date, so unless you really need the current time, avoid using Now() as it will only complicate thing as you have found out.

Ah yes!! Thanks for the help..