1 Reply Latest reply: Oct 1, 2014 3:21 PM by Gysbert Wassenaar RSS

    Set Analysis: Date Range + 1 more date

      Hi All,


      I need to create a set analysis which will output dates:


      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



      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?