Matrix: Date Columns

[HenryJS]

Hi all,

I have created a matrix with Weeks along the columns. 

Action Name is the rows and a count of 'Action Ref' in the values. 

But the data isn't picking up the date values? Tables are joined Action Date - Date

Export Actions

UserName	ActionRef	ActionName	ActionDate
Jami Thirkettle	2748316	CV Sent	02/12/2019 17:11
Sarah Schofield	2747219	Email - Password Sent	02/12/2019 15:22
Izabela Mylak	2747220	Create Contact - Manual	02/12/2019 15:23
Izabela Mylak	2747221	Agreement - Accepted	02/12/2019 15:23
Katie Peachey	2747222	Create Contact - Manual	02/12/2019 15:25
Dominika Roman	2750263	Not Progressing	02/12/2019 17:21
Dominika Roman	2750264	Not Progressing	02/12/2019 17:21
Dominika Roman	2750265	Not Progressing	02/12/2019 17:21
Dominika Roman	2750266	Not Progressing	02/12/2019 17:21
Dominika Roman	2750267	Not Progressing	02/12/2019 17:21
Alan Freer	2751110	New Job	02/12/2019 20:12
Alan Freer	2751111	Considering	02/12/2019 20:14
Alan Freer	2751112	Considering	02/12/2019 20:14

[amitchandak]

@HenryJS,

Remove time stamp from ActionDate before joining to date table

ActionDate 1 = [ActionDate].Date

[HenryJS]

@amitchandak returned below error

[parry2k]

@HenryJS you should change the data type of Action Date column to date and that will do it.

[amitchandak · Accepted solution]

Try

ActionDate 1=date(year([ActionDate]),month([ActionDate]),day([ActionDate]))