=INT(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"oaoboc" wrote in message
...
How do I remove time from a date and time field? Format removes the
display
but I need to filter to just show unique based on the day. Since the time
is
part of the field, I am not able to receive the filtering by day.