Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to create a set analysis which will output dates:
example:
If I select the Month (October)
I will output the last day of the month as of today, then i will output the dates for last month which fall on sundays
Date
Oct 1
Sep 7
Sep 14
Sep 21
Sep 28
I can already output the range from Sep 7~Sep28. Concat({<date={">=StartDate<=Prevmonthlastdate"}, DayName={'Sun'}>}Date)
How can I incldue Oct1 in the selection in my set analysis?
Concat({<Date={">=StartDate<=Prevmonthlastdate","Oct 1"}, DayName={'Sun'}>}Date)