8 Replies Latest reply: Feb 16, 2015 1:51 PM by Henric Cronström RSS

    Sorting by date DD/MM/YY

      I've been searching this community for ways to sort bar charts by date. I've seen some examples in which people asked for sorting graphs by month (in which the suggestion is to use MonthStart), but I would like to sort by day.

       

      In the data load editor I'm loading the date by using the following code:

       

      Load

          Date("Trade Date",'YYYY-MM-DD') as "Trade Date",

          Identifier

      FROM [lib://Desktop/sheet1.xlsx] (ooxml, embedded labels, table is 'sheet1');

       

      Who knows how to do this?