re: month end

[#1]

HI all..

need help please...

i have to get the month end of the selected period...

i have month ,year,monthyear,week,quarter in my selections..if any of this is selected then i need to get the max of month end of the date.

how can it b done..

please suggest

[tamilarasu]

Hi Reena,

You can use MonthEnd function. See below example from help file.

[anbu1984]

If you have Calendar table, then add Month End Date to this table

[senpradip007]

Try use this

Monthend(Max(Date))