Forum Discussion
Matrix Table Rollup
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 ...
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
amitchandak
Super User
Super UserAnonymous , 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