date format in field

[sbrady19]

Im in a table in design view. In the General tab at the bottom, I have:

Format: Short Date
Input Mask: 99/99/0000;0;

when I go to a new record I get this:
2/25/2015 2:25:23 pm

I just want the date ONLY......how do I do this....thanks.

[Rawb]

Check your Default Value: It should be Date() (or just Date, either works). Also make sure you're working with a local Table and not a Linked Table if you make changes, otherwise they won't be saved.

If you are still seeing time values and your Format: is Short Date and your Default Value: is Date() then the Table may be corrupt.

Make a backup of your database and then run a Compact and Repair. If that doesn't work, then you can try creating a new Table and running an Append Query to copy all your data over.

[sbrady19]

I put =Now() in the default so that field always gets todays date, I just need 2/25/2015 WITHOUT 2:23:12 PM. So would it be:

=Date NOW()

or something similiar? thanks.

[Rawb]

If you just want the date to appear, then use:

=Date()

[sbrady19]

thank you so much.