date/time data type

I am creating a form using a calander and trying to link
the date back to the table in the database. the problem
I'm having is access is creating a time for the entry on
the table after I select short date in the format for the
entry. Does anyone know how I can remove the time from
the database entry or prevent Access from creating a time
for the date entry in the table?

Thanks in advance for any assistance you can give.

PS I'm a newbie at Acces

A date/time value always includes both a date and a time portion. This is
because the date/time value is a double precision decimal, where the integer
portion is the number of days since December 30, 1899, and the fraction
(decimal) portioin is the time in fractions of 24 hours (e.g., 0.25 = 6 AM
and 0.5 = 12 noon). If the value is just a date only, then the time portion
is zero. If the value is just a time only, the integer portion is zero.

How are you setting a date to the field's value? If you're using the Now()
function, then use the Date() function instead. Now returns date and time,
Date returns just the date, and Time returns just the time.

--

Ken Snell
MS ACCESS MVP

"Patrick" wrote in message
...
I am creating a form using a calander and trying to link
the date back to the table in the database. the problem
I'm having is access is creating a time for the entry on
the table after I select short date in the format for the
entry. Does anyone know how I can remove the time from
the database entry or prevent Access from creating a time
for the date entry in the table?

Thanks in advance for any assistance you can give.

PS I'm a newbie at Acces

Thanks that works perfectly. I was using the now()
instead of date().

Again Thanks a million!
-----Original Message-----
A date/time value always includes both a date and a time
portion. This is
because the date/time value is a double precision
decimal, where the integer
portion is the number of days since December 30, 1899,
and the fraction
(decimal) portioin is the time in fractions of 24 hours
(e.g., 0.25 = 6 AM
and 0.5 = 12 noon). If the value is just a date only,
then the time portion
is zero. If the value is just a time only, the integer
portion is zero.

How are you setting a date to the field's value? If
you're using the Now()
function, then use the Date() function instead. Now
returns date and time,
Date returns just the date, and Time returns just the
time.

--

Ken Snell
MS ACCESS MVP

"Patrick" wrote in message
...
I am creating a form using a calander and trying to
link
the date back to the table in the database. the
problem
I'm having is access is creating a time for the entry
on
the table after I select short date in the format for
the
entry. Does anyone know how I can remove the time from
the database entry or prevent Access from creating a
time
for the date entry in the table?

Thanks in advance for any assistance you can give.

PS I'm a newbie at Acces


.