showing only date not time

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

Guest

I've added a field on my form that automaticly fills in the date. But it
also shows the time. I put now() in the Default value. Is there a way where
I can ONLY show the date and NOT the time?

Thanks
 
Set the Default Value to:
=Date()

To fix the existing records, run an Update query and use DateValue() to lose
the time component.
 
Thanks to you both. It's these little minor things that can really drive you
crazy. Well at least I was close.
 
MS said:
Thanks to you both. It's these little minor things that can really
drive you crazy. Well at least I was close.
Click to expand...

Just to give you a fuller picture here...

Access DateTimes ALWAYS contain a Year, Month, Day, Hour, Minute, and
Second. When we informally describe an Access DateTime "Containing only the
time" what we really are talking about are times of day that occured on
12/30/1899. Similarly, when we describe a DateTime that "Contains only the
Date" what we really are describing is a Date having a time of exactly
midnight.

It is just that Access chooses to suppress the display of the date
12/30/1899 and the time of midnight unless you explicitly force it to.

Being aware of this makes some of the DateTime behaviors that you will
encounter easier to understand.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dafault value for date not working with Date() but Now() is workin 3
Date and time onto a form 1
Show null values in Query 0
Form that Auto Fills Current Date, but does not show up in Query 1
Excel Excel Show Countdown Date 7
What am I missing in this statement, >=[Begin Date] And <=[End Date]? 8
autofill a field on a form with default value 2
Changing a Medium Time 5

Back
Top