By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,603 Members | 1,000 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,603 IT Pros & Developers. It's quick & easy.

Need help with a Date Format Please.

P: 56
Hi all, I have a situation that is requiring me to make an Entry Date part of the Primary Key. Problem I am having is that it includes the time too.

What I have is an inventory return table.
It consists of 3 fields - Date, Serial #, Model #

Currently I have the Serial # & Model # taged as the Primary key -


Now I am being told that items might come back more than once...

The primary keys are set to prevent accidental re-entry

If I add the Date to the Primary Key, that should allow for duplication of the item - but not prevent accidental re-entry because the time stamp will always be different. (we use a sometimes we get duplicate entries.)

So is there a way to store the date as a date w/o a time?

I am sure this is easy, and probly staring me in the face...but I am at a complete lost.

May 22 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
If the date field is actually defined as date/time in Design View of your table, select the field then goto the bottom and click on Format, then select Short Date. How are you actually entering the date?
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.