Get the highest date of related records in related table
I'm looking for a way of getting the highest date of all related records in a related table
v = TrimAll ( Substitute ( List ( Audit of Tasks Dot Highest Date::Date Done to Numbers ) ; [ Max ( Audit of Tasks Dot Highest Date::Date Done to Numbers) ; "" ] ; [ ¶ ; " " ]) ; 0 ; 0 ) ;
v = Substitute ( v ; " " ; ";" )
If ( v ; Evaluate ( "GetAsDate ( Max(" & v & "; 1 ) )" ) )
See attached screen grab or results giving the second highest date and not the highest... I cant seem to see how tho get the highest not the second highest.
Any help or advice would be appreciated.
All I want to do is get the most recent date the task was carried out and put it next to the Tasks require for a reference to when it was las done. I will use it for the calculation of overdue flag needs action.