4 Replies Latest reply: Aug 16, 2011 6:41 AM by Or Shoham RSS

    Best ways to create clickable month\year objects

    Michael Ellerbeck

      So I have some simple data that I wanted to allow date sorting on.

       

      The rows are like

       

      Sales order,    amount,    ship_date

       

      So during the load I just used

       

      Load *,

      num(month(Shipment_Date)) as Month,

      year(Shipment_Date) as Year;

       

      This gets me the desired result of being able to click on say the 1 and select all of January.

       

      Is there a better? different? more creative way of doing this? How would you do it?