Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Split date column into day/week/year

I have a date column that I am using in a matrix but it doesn't allow me to split it into day/week/year. Ideally, I would like my end user to be able to see the stepped values. From past experiene if...

Greg_Deckler
7 years ago
Hmm, well before they added that feature we used to just create colums like:

Year = YEAR([Date]) Month = MONTH([Date]) Day = DAY([Date])

And put them in the matrix Rows area as an ad-hoc hierarchy.

Icon for Community Champion rank

Community Champion

7 years ago

Hmm, well before they added that feature we used to just create colums like:

Year = YEAR([Date])
Month = MONTH([Date])
Day = DAY([Date])

And put them in the matrix Rows area as an ad-hoc hierarchy.