I am trying to get a filed to display the last admission dates and I get nada. What I have for the field calc. is :
field= If ( (Count ( Admission date))<2; ""; GetNthRecord ( Admission date; (Count ( Admission date))-1) )
I thought this would go: If there is only one record return nothing if more than one go to the end of the repeating field Admission date and get the second from last. I am desperatly confused, please help.
field= If ( (Count ( Admission date))<2; ""; GetNthRecord ( Admission date; (Count ( Admission date))-1) )
I thought this would go: If there is only one record return nothing if more than one go to the end of the repeating field Admission date and get the second from last. I am desperatly confused, please help.