Default value for NOW()

[Guest]

I have a table that has a date field set to Short DATE with a default value
of NOW().
When I enter data in my form, it always shows the time also, even tho the
form is set for the same NOW and date format.

When I do a search on the date field, I get no records returned because I'm
not entering the time also.

Is there another default value for NOW() I should be using?

 

[Mark]

Try using Date() instead; it will return only the date and not the time.

 

[Wayne Morgan]

Donna,

The reason for this is because Format only changes the way the item is
displayed, not what the item actually is. Since you are using Now(), you are
getting the current date and time. If you only want the current date, try
the Date() function instead.

To search by date on a field containing date and time you can use a
calculated field in a query to format the value to date only and then do the
search on that field.

Example Field:
DateOnly: Format([Table1].[DateField], "Short Date")