How can I remove the timestamp from a date field?

J

JennD

I have an Acces db at my company that uses a date field that automatically
has a timestamp along with the date. I only need the date for the purpose of
my db and the timestamp really gets in teh way. What is the function or
expression needed to eliminate the timestamp completely?
 
K

KARL DEWEY

In table design view click on the field and delete the DEFAULT property
information.
 
J

JennD

When I go to the DEFAULT Value for this field nothing is there. I have tried
using the FORMAT for this field and changing it to short date, which then
shows the short date in the field but when you click on it the timestamp is
still present. These timestamps come from queries automatically generated
from our company databases, which is why the timestamp is there in the first
place. I have these existing tables with timestamps and want to eliminate
all times from them and allow only the short date to be inserted each time I
update the db with new data.
Thanks Karl,
JennD
 
C

Chaim

Do you want to get rid of that field entirely from your table definitions?
If so, in Table Design View, select that row so that the entire row is
highlighted and hit the DELETE key. But be very certain you want to do that
before doing so. It is not retrievable, short of restoring the table from a
backup. You do have a backup?

If you want to kill the time piece of timestamp and leave only the date-
i.e., you want to keep the field but have only date information in it- try
using the DateValue() function. It will return just the date part of a
date/time expression.

Good Luck!
 
J

JennD

The latter part of yur response is what I am trying to do, I want to keep the
field but take out the time to show only the date. I have tried using the
DatePart() function but got errors.
I am definitely flying by the seat of my pants on this function as I work in
Access daily but rarely have to work a function for our purposes here. This
issue is something that my sup. and I have been trying to figure out for a
few months, on and off, and we have had to use work arounds to get the time
out of the field which takes a lot of time.
If you know of a good way to achieve this using the DateValue() function
please let me know, and I will be so greatful.
JennD
 
K

KARL DEWEY

In table design view click on the field and change the DEFAULT property
to =Date().
 
Top