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:

      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?