Variable Syntax

[#1]

I need to create two variables. The first is the start month of my fiscal year and the second my fiscal year start month +12. I currently have the two below variables but the syntax is incorrect.

Any help would be greatly appreciated.

=date(monthstart(04-2011),'MM-YYYY') (This is titled vStartMonth)

=date(addmonths(vStartMonth,12),'MM-YYYY') (This is titled vFiscalYear)

Thanx

[erichshiino · Accepted solution]

Hi, you can write the first like this:

date(monthstart(date#('04-2011','MM-YYYY'))) (without the = on the variable definition)

date(addmonths(($(=vStartMonth)),12),'MM-YYYY') (for vFiscalYear, also without the 😃

When you need to include it in a text box, you can call it like this:

=$(=vFiscalYear)