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]))

amitchandak's avatar
amitchandak
Super User
6 years ago

HenryJS,

Remove time stamp from ActionDate before joining to date table

 

ActionDate 1 = [ActionDate].Date

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

amitchandak returned below error

 

  • amitchandak's avatar
    amitchandak
    Super User
    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.