How can we make variable Dynamic?

[Anonymous]

Hi Everyone,

I have a variable vMonthENDDATE=date(monthend(today(),0),'YYMMDD').....Which returns the current year monthend date (20161031)

I have make this variable take current year month date as default value as well as make it dynamic for other all other month and date too..

How can I make this variable work in such a way?

User have Fiscal year and Month as the selection.

Thanks

Juna

[sunny_talwar]

May be use this:

Date(Floor(MonthEnd(Max(DateField))), 'YYMMDD')

or

Date(Floor(MonthEnd(MakeDate([Fiscal Year], [Month]))), 'YYMMDD')