Pick the most recent date

[london1980]

Hello,

One of my tables has dates and comments for SKU's in my catalogue. I just want to see the most recent comment in my Straight Table.

     Date              SKU          Comment

-----------------      ------------    ----------------------

05/11/2015         B123       Will be available in 23/Nov       --------------> most recent comment that I want to see

04/11/2015         B123       Awaiting response

Can anyone help with a solution?

Thanks

MT

[swuehl · Accepted solution]

Try

=FirstSortedValue( Comment, -Date)

assuming Date has a numeric representation, like a Date created by QV date functions.

[Anonymous]

Another way is to use

=Max(Date)

This function can be used in the script or on tables as well so quite nifty.

[Anonymous]

You can try:

LastValue(Comment)

group by Date