MOnth

[#1]

I m using below exp

vMonth and cMonth

Only({<[Month]={$(vMonth)}>}Visits)

Only({<[Month}={$(cMonth)}>}Visits)

to calulate visits for two month selected by user from input box.

now i want to do minus 1 from vMonth and cMonth in this exp i have used many

but not getting current result.

can any baody give right exp how to modify above exp so that it will select minus one month selected by user in input box

when user select june ,i want select may by using above two exp.

[#2]

your Month value are Jan, Feb....? or 1,2,3?

try

month(makedate(2012,$(vMonth)-1,1))

[#3]

may month is jan ,feb..........

[#4]

month(makedate(2012,$(vMonth)-1,1))

it is not any working

is there any other solution to subtract month.

[Jason_Michaelides]

You could try:

Only({<[Month]={"=$(AddMonths(vMonth),-1)"}>}Visits)

Hope this helps,

Jason