1 Reply Latest reply on Aug 8, 2014 9:27 AM by philmodjunk

    relationship sort help



      relationship sort help


           hello.  I have have a maintenance table that is related to my inventory records.  I have it sorted in the relationship by maintenance date but I want new records (that don't yet have a date) to be displayed at the top of the portal.  Any ideas?  Thanks!

        • 1. Re: relationship sort help

               Ascending or Descending order by date?

               I would guess that you have Descending order.

               Define a calculation field (with a date result type) that need not be used anywhere but in this relationship:

               If ( IsEmpty ( YourdateField ) ; Date ( 12; 31; 2095 ) ; YourDateField )

               Sort in descending order on this calculation field.

               Then make a note to yourself that you'll need to modify this design in 2095 wink