Using a less than (<) modifier in set analysis

[#1]

Hi all,

I have a data set that contains dates (INSTDATE) and values (LENGTH).

I want to use set analysis to sum all values less than the date given. The date given will be an input variable which the user enters. Lets say for this example that the date is 01/01/2010.

My attempts at set analysis expressions:

Sum ( {< INSTDATE < {'01/01/2010'} >} LENGTH)   ---> doesnt work, can't seem to use < symbol as a modifier

Sum ( {< INSTDATE = $(<'01/01/2010') >} LENGTH)  ---> doesn't work

Can anyone tell me how to use a less than operator in set analysis please?

Thanks

Dan

[#2]

Its sorted now, thanks to the links on the right providing another post with the answer!

I use:

Sum ( {< INSTDATE = { "<=$(varname)" } >} LENGTH)

Shame this method isn't in any of the documentation!

Thanks for looking!

Dan

[SunilChauhan]

use this

Sum ( {< INSTDATE = { <(''01/01/2010')" } >} LENGTH)

will this useful?