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

    Sort by date - Replaced Nulls with text

      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!