Depending on date selection should find the start and end of the month and output list of name that falls on the particular month

[Anonymous]

Hi,

I need to find the MonthStart and MonthEnd depending on a current selection of Date in the calendar and should show the store names which was opened in the particular month. I have a separate filter for store open date.

The expression I used is:

=If($(=Max(Month(ACT_DT_OPEN)))>=Monthstart($(=Max(Month((ACT_DT_OPEN))))) and <=MonthEnd($(=Max(Month((ACT_DT_OPEN))))), STR_NM)

But I am not sure this is correct.

Moreover, user should select the date from calendar and it should link with Actual open date

Anyone, please help me solve this.

[Anil_Babu_Samineni]

Expression seems, Not good to me. Can you check the same or provide sample

[Anonymous]

Yeah, my expression checks only the actual open date and not with the calendar date.

I need right way to proceed with it.

My idea is to find the start date and end date from calendar selection.. and to use interval match of actual date to list the names. But need a way to solve this.