date/time data type

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

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.
 
Thanks that works perfectly. I was using the now()
instead of date().

Again Thanks a million!
 
Back
Top