4 Replies Latest reply: Dec 13, 2011 3:36 AM by annie.lovelace RSS

    Date formatting

      Hello !

       

      I think I remember that QlikView can formatting the date when we insert it from an excel file.

      I have my date DD/MM/YYYY and I want to sort my data by day, month , year and week.

      I know that for example if I want to sort by month I can write "date(monthstart(DATE),'MM/YYYY')"

      But is it possible to count weeks (from 1 to 52) ?

       

      Please help me ...

       

      Annie