Syntax question for Month number in set analysis

[salleninsd]

Hello,

I am having trouble with the syntax in my set analysis.  I am trying to change the top formula to a formula that adjusts for each month as the year progresses.  I need help with the syntax in the bottom formula:

[AEQuota.QuotaMonth]={">=1 <=11"}

[AEQuota.QuotaMonth]={">=1 <=Num(Month(Date(($(vLastMonthEnd)))))"}

vLastMonthEnd is a variable that returns 2018-11-30, so I'm trying to get to the month number in the formula.

Thanks in advance for any help you can provide!

Scott

[rwunderlich]

Can you post the definition of vLastMonthEnd?

-Rob

[salleninsd]

Please disregard.  I figured out that I should create the variable first, then use it in my syntax.

Solution works:

[AEQuota.QuotaMonth]={">=1 <=$(vLastMonthNum)"}

[salleninsd · Accepted solution]

Hello Rob,

I think I figured it out.  I needed to create the variable first, then use it in the syntax.  It now works with the variable that I created:

[AEQuota.QuotaMonth]={">=1 <=$(vLastMonthNum)"}

Thank you so much for your quick response!  Have a great evening!