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

[Guest]

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?

 

[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.

 

[Guest]

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!