Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To whom it may concern,
I’m just a rookie at Qv and I’ve been trying for some time now to construct a table capable of calculating the most recent date from a set of dates considering a limit date. For example, if the script table goes like the following:
Client | Date | Payment |
Hugo | 12/05/2014 | 50000 |
Hugo | 20/07/2014 | 20000 |
Hugo | 30/09/2014 | 30000 |
Luis | 15/02/2014 | 80000 |
Luis | 26/03/2014 | 40000 |
Luis | 30/06/2014 | 90000 |
Luis | 25/10/2014 | 70000 |
And the “limit date” is 25/07/2014.
Then the table I wish to build should return the following results:
Client | Date | Payment |
Hugo | 20/07/2014 | 20000 |
Luis | 30/06/2014 | 90000 |
Thanks in advance!
Enrique,
when you say Limit date, are you expecting to show the latest value for Hugo, Paco and Luis but that are less than 25/07/2014 ?