Sorting Distinct Values by Date_of_Invoice

Sorting Distinct Values by Date_of_Invoice

Hey I have a table that I want to display, and right now it's sorting by the name of the trust or company so the data isn't in the correct order. I need the data to display by the invoice date, but I can't figure out for the life of me how to get it to display in the correct order.

The code so far is as follows: 
  2. TrustDistinct = Finances[Display_Name == searchParam && Line_Item.containsIgnoreCase("Trust")].distinct(Line_Item);
  3. for each  Expense in TrustDistinct
  4. {
  5. // Add all of same trust together to get total for each field
  6. DisbursementFromTrust = Finances[Display_Name == searchParam && Line_Item == Expense].sum(Amount);
  7. DisbursmentFromTrustFormatted = "$ " + DisbursementFromTrust.round(2);
  8. //TMCo is equal to Trust Management Company
  9. // listOfDates = List:date();
  10. // listOfDates.add(Finances[Display_Name == searchParam].Date_of_Invoice);
  11. // datesSorted = listOfDates.sort(false);
  12. DisbursementDateFromTrust = Finances[Display_Name == searchParam && Line_Item == Expense] sort by Date_of_Invoice;
  13. AttorneyFees = Finances[Display_Name == searchParam && Type == "Attorney Fees" && Line_Item == Expense].sum(Amount);
  14. AttorneyFeesFormatted = "$ " + AttorneyFees.round(2);
  15. AmountToClientExpenses = Finances[Display_Name == searchParam && Type == "Client Expenses" && Line_Item == Expense].sum(Amount);
  16. AmountToClientExpensesFormatted = "$ " + AmountToClientExpenses.round(2);
  17. //TotalBalancePaid = AttorneyFeesFormatted + AmountToClientExpensesFormatted;
  18. DisbursementToClient = Finances[Display_Name == searchParam && Type == "Disbursement to Client" && Line_Item == Expense].sum(Amount);
  19. DisbursementToClientFormatted = "$ " + DisbursementToClient.round(2);
  20. DisbursementToMedicare = Finances[Display_Name == searchParam && Type == "Medicare / Medicaid Liens" && Line_Item == Expense].sum(Amount);
  21. DisbursementToMedicareFormatted = "$ " + DisbursementToMedicare.round(2);
  22. //Check No. Need to configure
  23. //DateOfDisbursement = Finances[Display_Name == searchParam && Type == "Disbursement to Client" && Line_Item == Expense];
  24. //Trust = Finances[Display_Name == searchParam && Type == "Disbursement to Client"];
  25. %>
  26. <div class="divTableRow">
  27. <div class="divTableCell1"><%=Expense%></div>
  28. <div class="divTableCell1"><%=DisbursmentFromTrustFormatted%></div>
  29. <div class="divTableCell1"><%=AttorneyFeesFormatted%></div>
  30. <div class="divTableCell1"><%=AmountToClientExpenses%></div>
  31. <div class="divTableCell1"><%=DisbursementToMedicareFormatted%></div>
  32. <div class="divTableCell1"><%=DisbursementToClientFormatted%></div>
  33. <div class="divTableCell1"><%=DisbursementDateFromTrust.Date_of_Invoice%></div>
  34. </div>