Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use this:
Date(Floor(MonthEnd(Max(DateField))), 'YYMMDD')
or
Date(Floor(MonthEnd(MakeDate([Fiscal Year], [Month]))), 'YYMMDD')