2 Replies Latest reply: Apr 29, 2013 3:48 PM by David Koschei RSS

    Sort by date - Replaced Nulls with text

    David Koschei

      Hi everyone,

       

      I have a field that contains dates.  The date will sometimes be null, so I replaced nulls with "Open" in the script. 

       

      I have a bar chart where I want the dates to be in ascending order, but "Open" to be last, not first.

       

      It is currently sorting it as: Open, Jan 2013, Feb 2013, Mar 2013, etc.  I want the dates to stay in this order, but Open to appear at the end, not the beginning.

       

      Thank you!