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" <oaoboc@discussions.microsoft.com> wrote in message
news:3738BBD8-BE54-48E5-BE6A-3C3393B918A0@microsoft.com...
> 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.