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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
It would be a Formual Text field like

If[IsNull([my date field]), �Blank", " not Blank")

Unless you wanted a different formula to check all the date fields.