?
Solved

Sorting Views by Date (month)

Posted on 2005-03-29
5
Medium Priority
?
204 Views
Last Modified: 2013-12-18
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?
0
Comment
Question by:Jaziar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
BarryTice earned 500 total points
ID: 13657701
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
 
LVL 7

Expert Comment

by:BarryTice
ID: 13657709
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
 

Author Comment

by:Jaziar
ID: 13661662
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
 

Author Comment

by:Jaziar
ID: 13662228
This issue has been solved :)
0
 
LVL 7

Expert Comment

by:BarryTice
ID: 13662271
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question