Sort by date - Replaced Nulls with text

[#1]

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!

[nagaiank · Accepted solution]

In the Chart properies, Sort tab, sort date by the followint expression ascending:

If(Date='Open',999999,Date)

[#3]

That did it! Thank you