Forum Discussion

HenryJS's avatar
HenryJS
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 ar...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

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

parry2k's avatar
parry2k
Super User
6 years ago

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