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?