Invoice "Date Due" question
On the "Event Invoice" layout I have a 'Date Due' field that worked fine calculated as EVENT::StartDate - 7. However it is possible for customers to order tickets for multiple events with different start dates.
How do I make 'Date Due' look at the earliest of multiple start dates? (Invoice table and Event table has a LineItem (join) table which they both relate 1-to-many to). I have a portal on the Invoice layout that looks at Line Items and the portal records are sorted by event Start Date.