Help With Last()

I’m trying to grab the last entry in a date sorted table.

I’m using

Last([Michelle's Wins]).Wins

Which returns

Confirmation for 6 2012 server decoms, Kudos from Donna about a document that helped her with an issue, ACI build successful

The table values are:

Date	Wins
6/8/2022	Assisting with on-call, assisted with issue.
6/1/2022		Confirmation for 6 2012 server decoms, Kudos from Donna about a document that helped her with an issue, ACI build successful
5/25/2022	Print issue with Cynthia and CTE,
5/11/2022	Resolving Infiniti Middleware Lab issue, Voicebrook had a successful go live, Aging hardware remediation 

Why isn’t this returning the entry for 6/8/2022?

I understand now. I added sort() and now it is function as I wanted.

As you are attempting to grab a date from a list you can likely skip sort() and just use max() to pull the most recent date

1 Like