remove time in Acess

[Guest]

My query's result showed date and time together "8/1/2006 4:44:00 PM". How
do I parsing out the time. I just want to append date to other query.

 

[fredg]

My query's result showed date and time together "8/1/2006 4:44:00 PM". How
do I parsing out the time. I just want to append date to other query.

A Date datatype field always includes a Time value as well as a Date
value. If the Date has been saved using Date(), or if only a date
value has been entered, the Time value is 0 (midnight).

Just append the Date field as is.
To display (after it's been appended) just the date, set the format
property of the control to "short date" or mm/dd/yyyy.

 

[Douglas J. Steele]

If you're getting date and time, odds are you used Now() to populate the
field. Use Date() instead.

To get only the date component, use the DateValue function (to get only the
time component, you'd use the TimeValue function)

To permanently remove the time, run an Update query:

UPDATE MyTable Set MyDateField = DateValue([MyDateField])