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
No, use that field as a dynamic filter on the left side of the report.  It will instantly filter your report.

As for various permutations, try this enhanced formula

If(
IsNull([APPT? 19]) and IsNull([APPT 19]), "Both Blank", 
IsNull([APPT 19]), "APPT 19 Blank",
IsNull([APPT? 19]), "APPT? 19 Blank", 
" none Blank")