Solved

Sorting Views by Date (month)

Posted on 2005-03-29
Medium Priority
204 Views
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
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
• 3
• 2

LVL 7

Accepted Solution

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.

-- b.r.t.
0

LVL 7

Expert Comment

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

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

ID: 13662228
This issue has been solved :)
0

LVL 7

Expert Comment

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

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…
Suggested Courses
Course of the Month12 days, 17 hours left to enroll