I have a column which is used for component completion date. The latest
date is teh complition date for teh project. I am using MAX(field:field) to
select the latest date. However, we are running across the occurance where a
date is TBD(to be determined) How can I choose the TBD if it is present in
the column over the max date?