I'm trying to set up a sort of a date field to generate a daily follow up list.
The problem I'm having is although each record contains a "Follow Up" field, they will be blank if that particular record is not scheduled for a follow up. When I try to sort Ascending, it puts all of the blank fields first w/ the completed ones way at the bottom of the list (over 3600 records). If I sort descending, it puts the farthest away dates at the top of the list.
How do I weed out all of the blank date fields and get the dates closest to today at the top of the list?