1 of 1 people found this helpful
Yup. Set up your portal so it's sorted chronologically in descending order. Do this by double-clicking on the box between Clients and RDV in the Relationships diagram and then specifying the sort order for the RDV side of the relationship:
The topmost date in your portal will then be the most recent meeting.
Within your Clients table, create the Calculation field "Next Meeting" (type Date), = CDV::Date + 186. It will use the topmost "Date" value from your portal. Display "Next Meeting" wherever you want on your Clients screen, but probably somewhere near the CDV portal.
No need to sort anything; use
Min ( CDV::Date )
to get the oldest related date.
If you want to go ahead 6 months, rather than the arbitrary amount of 186 days:
o = Min ( CDV::Date ) ;
Date ( Month ( o ) + 6 ; Day ( o ) ; Year ( o ) )