variable issue

[#1]

Hi Experts,

I have to set variable for the following expression

'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

when i give like

vCurrMnth='>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

it is giving error.

Pls help me to solve this

[sunny_talwar]

Try defining the variable like this may be and check if that works:

vCurrMnth= ='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate))

Best,

Sunny

[#3]

its showing null value

[sunny_talwar]

Are you using the above in a set analysis expression?

There are few things that could be going wrong?

1) variable should be ='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate)) with the equal sign

2) What is vMaxSalesDate? Is it an actual date?

Would you be able to share a sample application?

[b_garside]

Is this being used in a Calendar object as a search string?

[#6]

vMaxSalesDate=Date(Max(Calendardate))

i try checking with text box.

it is just displaying as it is

[#7]

i hav to use this in an expression of pivot table.

pls help

[sunny_talwar]

Are you trying vCurrMnth or $(vCurrMnth)? My guess is that you are trying vCurrMnth. Try $(vCurrMnth) and see what you get.

Best,

Sunny

[#9]

now the text box is showing value as

>= 01/06/2015 <= 05/06/2015

i need to use the below exprn in pivot table.

SUM({<MonthYear=,Date={'$(vCurrMnth)'}>} DAYS)

its showing null values

[sunny_talwar]

What is the format of MonthYear? If it is anything except 'DD/MM/YYYY', you won't see any results. You need to change the format of your variable to the same format as MonthYear.

HTH

Best,

Sunny