Matrix Table Rollup

[Anonymous]

I have a matrix table that is counting objects. There are phases to categorize the count (Phase 1 / 2 / or unphased). All of the counts should be rollup into "DATE_INSERTED". Why are there multiples of the same dates? Shouldn't the counts just roll up into 1 date? See screenshot below for reference. 

Ex: Jan 7 / Jan 5 / Jan 4 > Shouldn't these dates be rollup individually and not broken into duplicates? 

How can I fix this? 

[amitchandak · Accepted solution]

@Anonymous , One of the doubts I have is that date has a timestamp.

So change datatype to datetime and take format with time and check.

If it has time, Then create a date column like

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

and use that