num(month(date))

[#1]

in calendar i have month sequence column  - created using num(month(date)) as monSeq

now i want to use set analysis to get previous month .

i use -            monSeq={">=$(=max(monSeq)-1)<=$(=max(monSeq))"}

i am not clear with what number we are subtracting ?

is it date / week / month

behavior for today date:

=max(monSeq)-1)     -> march

=max(monSeq)-2)

-> march

=max(monSeq)-3)

-> march

=max(monSeq)-4)

-> feb

can anybody please guide me , what are these number (number that we are subtracting) means day or week or month

[Gysbert_Wassenaar]

Without looking at the actual data we can't give you a definite answer. But my first guess would be month numbers.

[robert_mika]

What's  your data format?

As this

will give different value that this:

[#4]

'2015-03-17'

[robert_mika]

Please post sample of your data so we can better understand what we are dealing with.