I have a time with a few date fields. I have to fields set to "short date" but when I look at the table the fields are displaying in "general date" format. Can someone explain to me why this is?

Steve

Where do you have the fields set to "short date"? Remember this is a display setting, so if you set it on a form, it does not pertain to a table or report (each has their own display setting). Access stores the date the same way no matter what (as long as it is a date/time field) and will just "show" it depending on the display setting.

I figured out why the date field is diplaying this way. One of my forms I have a field set to Now() by default which is causing the field to display date and time. Is there a way to set this to exclude the time?

Use Date() rather than Now()

Also, there's a Time() function too. ;)