AnsweredAssumed Answered

Sorting question...

Question asked by Rackman on Dec 8, 2008
Latest reply on Dec 9, 2008 by raybaudi


Sorting question...


Hi again,


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?