Month:=@Select(@Month(CreatedDate);“January”; “February”;“March”;“April”;“May”;“June”;“July”;“August”;“September”;“October”;“November”;“December”);Month + ", " + log_CreatedYear
Hi, My view need to show documents sort by month and year. But one problem is that if I have two documents created in different date with same month and year, there are two categories in the view for same month. For example, I have document which created on March 3, 2005, and another document created on March 4, 2005. my view still show two March, 2005. That is not what I want. I want that the view show only one March, 2005 for all documents if same month and year, no matter date. How to fix it?
Subject: Re: Sort by month + year only in View
Just a hunch, but try using just a space instead of a comma and a space. It might be getting confused confused into thinking there are multiple values.
Subject: RE: Re: Sort by month + year only in View
I did that… but same problem…it still show two or more categorized in my view for same month.
Subject: RE: Re: Sort by month + year only in View
You forgot to mention the hidden sort column that appears before the categorized column, which sorts by CreatedDate so that the month categories will list in date order rather than alphabetical order. Even though the text of the category is the same, rows are grouped together in a single category only if they have the same value in the sorted columns to the left of the category column.
To solve this, you might use a formula such as the following in your hidden sort column:
@Date(@Year(CreatedDate); @Month(CreatedDate); 1)