Set Analysis: Date Range + 1 more date

[#1]

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?

[Gysbert_Wassenaar]

Concat({<Date={">=StartDate<=Prevmonthlastdate","Oct 1"}, DayName={'Sun'}>}Date)