5 Replies Latest reply: Mar 14, 2014 9:51 AM by Saradhi Balla RSS

    Sorting question

    Sara Titmuss

      Hello,

      I have a couple of date list boxes which are as follows:

       

      Year - YEAR_ACTIVITY

      Month - MONTH_ACTIVITY (sorted by expression MONTH_ACTIVITY_NUM)

      Day - MONTHDAY_ACTIVITY

       

      The month/day is shown as JAN(01) JAN(02) etc.  However when sorting this it does not load in month and numberical order.  (As you can see below).

      Can anyone advise on how to load this in month and numerical order, JAN(01) JAN(02) etc?

       

      (If it helps, it is loaded in the script as to_char(vat.EVTDATE,'MON(DD)') as MONTHDAY_ACTIVITY)