Forum Discussion

MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
7 years ago

Sorting blank date records in a number of fields

I have 3-4 date fields that have a large number of blank records and I wish to sort on all these fields in order, oldest to newest.  I don't want the blanks to come up first.  I've seen instructions h...
Tables and fields
MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
7 years ago
Sorry, will copy/paste in future.  So, that worked! Thank you!  Now I have to sort on that column first, then on APPT? 19 and APPT 19 next?  Also, is there a formula change that would be show "not blank" if *either* of the records had a date?