1 Reply Latest reply on May 4, 2009 3:16 AM by davidhead

    Sort order - date ascending but blanks at end

    WorkingOnIt

      Title

      Sort order - date ascending but blanks at end

      Post

      I am creating a work in progress report and I am sorting by due date in an ascending manner so that the report will prioritize the tasks due first. However, I have some tasks that do not yet have a due date - how can I put these tasks at the end of the report rather than the beginning, without giving them a due date?

      Thanks all

        • 1. Re: Sort order - date ascending but blanks at end
          davidhead
            

          Create another field called DueDateEmpty - calculation, number result = IsEmpty ( DueDate ). Uncheck the option 'Do not evaluate if all referenced fields are empty'. So records without a due date return 1.

           

          Then sort your records by DueDateEmpty (ascending) and then DueDate (Ascending). 

          This will put the records with an empty due date at the end, and sort those with a date as required.