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 UserNameActionRefActionNameActionDateJami Thirkettle2748316CV Sent02/12/2019 17:11Sarah Schofield2747219Email - Password Sent02/12/2019 15:22Izabela Mylak2747220Create Contact - Manual02/12/2019 15:23Izabela Mylak2747221Agreement - Accepted02/12/2019 15:23Katie Peachey2747222Create Contact - Manual02/12/2019 15:25Dominika Roman2750263Not Progressing02/12/2019 17:21Dominika Roman2750264Not Progressing02/12/2019 17:21Dominika Roman2750265Not Progressing02/12/2019 17:21Dominika Roman2750266Not Progressing02/12/2019 17:21Dominika Roman2750267Not Progressing02/12/2019 17:21Alan Freer2751110New Job02/12/2019 20:12Alan Freer2751111Considering02/12/2019 20:14Alan Freer2751112Considering02/12/2019 20:14

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

Post Prodigy

6 years ago

Solved

Matrix: Date Columns

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