Access97 CalendarControl8.0 Date Selection puts date AND time in f

  • Thread starter Frustrated Kaiya
  • Start date
F

Frustrated Kaiya

I've used ActiveX CalendarControl8.0 in a form to feed a date field in a
table. However, despite setting the short date format, the field includes
the time -- this jacks up all the sorting I'm trying to do. How do I keep
the time from being included in this field in my table?
 
D

Douglas J. Steele

Access doesn't have a Date-only data type: the Date field holds both Date
and Time (it's an 8 byte floating point number, where the integer portion
represents the date as the number of days relative to 30 Dec, 1899, and the
decimal portion represents the time as a fraction of a day)

When you say that you're seeing a time, are you seeing midnight (the default
time when you select a date), or an actual time? If the latter, are you
using the Now() function to assign the date? If so, use Date() instead.
 
F

Frustrated Kaiya

Thanks! I did have now() in for the default. Midnight won't give my problem
as long as all of the dates have midnight. Now() seems to have been the
issue.

Thanks again!
 
Top