tricky formating question

[waely]

hi,
I have tricky question and I hope someone has an idea.
I have a report that has dates and formula for MaxDate. the dates should be sorted Asc. if the dates are null then I want them to show at the buttom so what I did is replaced the null value with 1-1-2070 so when sorted it will be at the buttom then hid it. this works good as for sorting but when I do the max it will use the 1-1-2070 date which is hidden and I don't want to use. please see attachement.

any ideas are appreciated.
Waely

[sraheem]

use a running total on date,use maximum as summary , based on formula.

formula can be

date < cdate(1-1-2070)

:-):wave: