How to get date without time. 1

[needadvice]

I have a data entry form with a text box that holds the current date. The date is set by default(date() in the default property setting.) This process is transparent to the user.
This method saves the date with the time. My user wants to sort on date. with the time included he only gets one record.(time specific).
I've set every option to "short date" but the time still appears. How can I save just the date?

 

[combo]

AFAIK, Date() returns only date portion, date and time is returned by Now().

combo

 

[needadvice]

The default is Date() but it still goes into the table with the time.

 

[JeremyNYC]

Any value stored in a date/time field will have both date and time, no matter what you do. That is the way things are stored in Access/Jet.

If you need to store just a date, with no time, you can get creative, storing it as text, a number, or three numeric fields.

But there's no way to change the field type.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[needadvice]

Thanks, that's what I needed to know.