set analysis date variable

[nareshthavidishetty]

Hi,

I need to add a date variable instead of Date Extract.

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=AddMonths(max([Date Extract]),-1))<=$(=max([Date Extract]))'}>}[# QN Open])

Date variable:

v_Caldate = date([Calendar Date],'DD-MM-YYYY')

Thanks...

[jyothish8807]

Try like this:

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=AddMonths(date(max(v_Caldate),'DD-MM-YYYY'),-1))<=$(=date(max(v_Caldate),'DD-MM-YYYY'))'}>}[# QN Open])

Just check the brackets.

Br,

KC

[Anil_Babu_Samineni]

I think, this deserve?

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=Date(AddMonths(max($(v_Caldate)),-1),'Your Format'))<=$(=Date(max($(v_Caldate)),'Your Format'))'}>}[# QN Open])

[shiveshsingh]

You need to replace your Date Extract with

$(v_Caldate)