topic Re: Show only the last record in table in App Development

Show only the last record in table

zied_ahmed1 — Fri, 15 Nov 2019 11:16:10 GMT

Hello ,

I need to show only the last record in the table (the record who have the max finish date :

In our example I need to display only Construction -> 25/07/2019

Thanks for help

Anil_Babu_Samineni — Fri, 15 Nov 2019 11:18:33 GMT

If([Finish Date]=Max(TOTAL [Finish Date]), [Finish Date])

zied_ahmed1 — Fri, 15 Nov 2019 13:09:02 GMT

Thank you for your answer but it doesn't work

StarinieriG — Fri, 15 Nov 2019 13:24:41 GMT

Hi,

maybe the formula doesn't work beacause of the field, that is not in a date format.

Try with:

If([Finish Date]=Max(TOTAL Date#([Finish Date],'DD/MM/YYYY')), [Finish Date])

zied_ahmed1 — Fri, 15 Nov 2019 13:40:11 GMT

Same problem..

My requirement is to display only the last task completed (On this project for example the last completed task is Construction 25/07/2019)

Thanks

Anil_Babu_Samineni — Wed, 20 Nov 2019 13:33:04 GMT

Try below expressions in text box and see?

Max(TOTAL [Finish Date])

Date(Max(TOTAL [Finish Date]))