default value for date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that collects dates (among other things). I have the default
value set to NOW() and the format set to short date 99/99/00;0_

When I enter data, the NOW default always adds the current time, even though
I've told it to use the short date format. So when I do a search on the date
field, it returns no records because I would need to know what time of day
also.

Is there some other default value for NOW() I should be using?
 
Back
Top