Fiscal Year 6 months

[bobbydave]

I have a formula that brings in the Fiscal Year Month for the last 6 months.

Right now, I am showing Nov-(start of) May.

What I want to do is show as far as the very end of April and not include May.

I have a variable vFiscalYearMonth6Months

=num(addmonths(MonthStart(today()),-6)) which brings in Nov until the start of May.

Any ideas how to remove May?

[sunny_talwar]

Is this used in script or set analysis? Can you share the where statement or the expression where this variable is used?