Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Expression seems, Not good to me. Can you check the same or provide sample
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.