Remove time from a date and time field? Format removes the displa.

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.

=INT(A1)

--

HTH

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


"oaoboc" <[email protected]> wrote in message
news:[email protected]...
> 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.