Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=FirstSortedValue( Comment, -Date)
assuming Date has a numeric representation, like a Date created by QV date functions.
Try
=FirstSortedValue( Comment, -Date)
assuming Date has a numeric representation, like a Date created by QV date functions.
Another way is to use
=Max(Date)
This function can be used in the script or on tables as well so quite nifty.
You can try:
LastValue(Comment)
group by Date