Set Analysis: Date Range + 1 more date

Wed, 01 Oct 2014 02:50:00 GMT

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?

Re: Set Analysis: Date Range + 1 more date

Gysbert_Wassenaar — Wed, 01 Oct 2014 14:31:22 GMT

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