AnsweredAssumed Answered

Calculation for most recent date

Question asked by mrosenhek on Oct 23, 2017
Latest reply on Oct 23, 2017 by mrosenhek


Can anyone tell me how to display the most recent date (from a related file) for/in the parent record?

I have used the GetnthRecord function in the past, to display data from the most recent related record, but now I need to find the most recent date (which may not be the last related record created.


This will display the data from the most recently created record

GetNthRecord ( Project_PROJECT_DESIGN::Design_Status_t ; Count ( Project_PROJECT_DESIGN::zkp_Project_Design_n ) )


This is what I have thus far but of course it works for the most recent related record, not the most recent DATE.


GetNthRecord (

employee_EHSFit::Date Tested ; Count (

employee_EHSFit::zkp_Fit_n )



Any takers? Thanks.