Sorting Views by Date (month)

I have a view for each month in the year - I also have view by year (Example)

|> 2005
     |> Data
          1 - January
          10 - October
          11 - Nov
          12 - Dec
          2 - Feb
          ETC

|> 2004 Ref
    |> Data
         1 - Jan
         ETC

Is there a way I can get these views to either display by date (Without the 1 - Jan etc) or atleast get 10 - 11 -12 under 9.

|> 2004 Ref
|> 2005
|> 2006

I know that view names are only text

2005\Data\1 - January

But there has to be a way?
JaziarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BarryTiceCommented:
Jaziar --

From what I understand, you have three fields there, right? ("Year", "whatever it is that has 'Data' in it", and "Month With Leading Number").

For the sake of simplicity, let's assume that third field is called "Month" rather than "MonthWithLeadingNumber".

Put a hidden column in before the one that shows the month. Sort it. Put this in it:
@Right("0" + @Trim(@Left(Month; 2)); 2);

@Left(Month; 2) will give you "10" for October, and "1 " for January (that's one-space).

Trim that to remove leading and trailing spaces, and you still have "10" for October, but now you have just "1" for January (with no space).

Add the text of a zero to the beginning of that and you get "010" for October and "01" for January.

Take the rightmost two characters, and you're set.

Alternately, you could use @TextToNumber(Month), and it will return a numeric value of everything in the Month field up to the first non-numeric character.

Your choice.

-- b.r.t.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BarryTiceCommented:
Oh, and if you then want the visible column to not have the number in it, use:
@Right(Month; "- ")

That finds the first occurrence of hyphen-space, and returns everything in the string beyond that.

-- b.r.t.
0
JaziarAuthor Commented:
I am more concerned about the actual view names.  I would like for the view names to be in order.  I don't think there is a way to make them line up, but was checking to make sure there are no tricks out there.

In my view list I have

2005
2006
2004

Is there a way for trick the system in to

2004
2005
2006
0
JaziarAuthor Commented:
This issue has been solved :)
0
BarryTiceCommented:
Oh, the views themselves and not the documents showing in the views?

Create a navigator with an outline that puts them in the order you like.

-- b.r.t.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.