2 Replies Latest reply: Oct 19, 2011 5:14 AM by Shubham Kumar RSS

    How do arrange the data in a coloumn where dates are Grouped by week.

    Shubham Kumar

      How do arrange the data in a coloumn where dates are Grouped by week.

       

      Weekday([ISSUED DATE]) as Weekdays) will return only the weekday, suppose if that day is sunday or monday. but the question is we need to make all the week days in one column, and the data for the week should be showing respectly in different columns.

      e.g. 17/10/2011-23/10/2011 (which is one week) that should come in the same row.

       

      weekday.png

       

      Best,

       

      Shubham Kumar

       

      join@aptjoin@aptojoin@apjoin@aptot