Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The requirement is like
if the user selects Jan 2022 the start date should be 31/12/2021 (start of the month [minus] 1 day) and the end date should be the end of the month ie. 31/01/2022.
StartDate:
Date(MonthStart(SelectedDate)-1,'DD/MM/YYYY')
EndDate:
Date(MonthStart(SelectedDate,1)-1,'DD/MM/YYYY')
Thank you Marco.
I want to apply logic in editor for the Month filter.
If I click on Jan it will work for entire dashboard.