Forum Discussion
HenryJS
Post Prodigy
Post ProdigyMatrix: 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...
Try
ActionDate 1=date(year([ActionDate]),month([ActionDate]),day([ActionDate]))
amitchandak
Super User
Super UserRemove time stamp from ActionDate before joining to date table
ActionDate 1 = [ActionDate].Date
HenryJSPost Prodigy
Post Prodigy- amitchandak
Try
ActionDate 1=date(year([ActionDate]),month([ActionDate]),day([ActionDate]))
