Get data from a range of dates (Obtener datos de un rango de fechas)

[#1]

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!

[ramoncova06]

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 ?