Sorting on a Date Field

[agutleben]

I have a .fp5 database that sorts on a date field. When records are sorted, any record with a null value in the date field is located at the end of the sort order. When I converted to .fp7 (using FM 8.5) the sort order is correct, but the records containing the fields with a null value are located at the start of the record set. How can I fix this?

Thanks in advance,

Aaron

[David Jondreau]

Create a calculation field of type date.

=Case(IsEmpty(DateFIeld); "1/1/2100"; DateFIeld)

and sort on that.

[AudioFreak]

Or just put a bunk date that you know is BS in the date field you sort on now.

Or if you can use FM 9 use the bunk date and use conditional formating to make it appear empty.

Edited August 10, 2007 by Guest