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
I was on an iPad and I think the wrong quotes got in here.

If(
[IsNull([APPT? 19]), "Blank", 
[IsNull([APPT 19]), "Blank", 
" not Blank") 

If that does not work, then please post your complete formula and the complete error message.