AnsweredAssumed Answered

Sorting question...

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

Title

Sorting question...

Post

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?

 

TIA

 

Joe 

Outcomes