Group field date

[MattThoms]

Hello all,

I am trying to regroup some date.

As you can see my original field is Activities_Cannib_Eventtime is in the format 'MM/DD/YY hh:mm:ss'.

I want to have one field for one date. Actually I am having several date with a different timeline for the same date.

How could I only take one date for each date ?

For example : I want to have only one time 7/29/2016 in the last column 

I already used distinct but didn't work [Distinct(date(Activities_Cannib_Eventtime)]

[maxgro]

maybe you need the date or time part of a timestamp

Date(Floor(Activities_Cannib_Eventtime ))

Time(Frac(Activities_Cannib_Eventtime ))