12 Replies Latest reply on Dec 2, 2016 5:13 AM by venkat.gunda

    Weekday filter

    sneha simha

      Dear All

                         I want Weekday and Weekend day as a filter which when selected, should show the names of the week.I found something closest but it shows the number

      case DATEPART('weekday',[DATE])

          WHEN 1 THEN 'WEEKEND'

          WHEN 2 THEN 'WEEKDAY'

          WHEN 3 THEN 'WEEKDAY'

          WHEN 4 THEN 'WEEKDAY'

          WHEN 5 THEN 'WEEKDAY'

          WHEN 6 THEN 'WEEKDAY'

          WHEN 7 THEN 'WEEKEND'

      END = [Day]

       

      and i have to use the Date and go to custom, also need to select weekday.

       

      Kindly help.

       

      Regards

      Sneha