Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[subway33]

Can someone help me build this view? Within this structure, I would like to see the months of the year in their correct form. After several attempts to create the expression, I was unable to succeed.

Thanks in advance.

[zybex]

Try:

Code: [Select]

formatDate([Date Imported, 0], year)\formatDate([Date Imported, 0], month)\[Artist, 1] - [ Album]&datatype=[list]


[subway33]

Thank you Zbex for your prompt help.

It seems that it is almost there, the order of the months is alphabetical, instead of the order of the months of the year.

[zybex]

For that you need to add the expression in 3 separate Categories instead of adding a single category with the full expression.

Category 1:
- name = Anos
- Group by = formatDate([Date Imported, 0], year)

Category 2:
- name = Meses
- Group by = formatDate([Date Imported, 0], MM)
- display = formatDate([Date Imported, 0], Month)

Category 3:
- Name = Albums
- group by = [Artist, 1] - [ Album]

[subway33]

Awesome Zybex!
Thanks for putting me in the right direction.
Very grateful as always.