Print

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

[locust]

Is there a more elegant way to nest decades than this? Maybe one that isn't so expression intensive.. I'm trying to optimise my views and don't want to over burden my view schemes with any unessential labour intensive expressions..

listbuild(1,\,removeright(formatrange([Year],10,2),5)'s,removeleft([Year],3))&datatype=[list]

Thanks

[rick.ca]

FormatDate([Date, 0], Decade)\[Year]&DataType=[List]

[locust]

Cheers, mate 

One step closer to a perfect setup 

[MrC]

Rick's expression is nicer, but here's one using the basic format you used, and deals with Unassigned Years:

Code: [Select]

if(isempty([Year]), Unassigned,
                   listbuild(1, \, removeright([Year], 1)0's, 'removeleft([Year], 2)&datatype=[list])</nobbc>

[locust]

That was along the lines I was going for, I think Rick expression will be less intensive on the cpu though.

I'm not really bothered about my expressions checking if there is a value.. I've got a custom scheme that is setup specifically for tag maintenance. I like to keep that stuff separate from my main view schemes.

Thanks anyway, it's cool so see multiple ways of doing the same thing   

[MarkCoutinho]

Forgive me, but as I'm Dutch I don't understand the meaning of 'to nest decades'. I think it might be of interest to me too, so can someone describe or 'translate' the meaning of this?

Thanks!

[rick.ca]

I'd be lost without them...

[JimH]

Forgive me, but as I'm Dutch I don't understand the meaning of 'to nest decades'. I think it might be of interest to me too, so can someone describe or 'translate' the meaning of this?

Nested means something like "contained within".  Explorer has folders nested within folders, for example.

Decades are the 1960's, 1970's, etc.