Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
How can I get the number of rows I have of the field (Fechamento), between Today() and Today - 1 Year?
Date | Fechamento |
12/05/2020 | 2 |
12/04/2020 | 3 |
12/02/2020 | 4 |
13/01/2020 | 5 |
14/11/2019 | 7 |
15/10/2019 | 6 |
15/09/2019 | 6 |
17/07/2019 | 8 |
17/06/2019 | 9 |
18/05/2019 | 2 |
18/04/2019 | 1 |
IN this example, I'm expecting 10 as result!
In other words, how can I get the number, of values between two dates? How can I count the quantity, not the total, of values between today and one year ago?
Thanks
Try this:
count({<Date = {">=$(=addyears(today(),-1))<$(=today())"}>} Fechamento)
Try this:
count({<Date = {">=$(=addyears(today(),-1))<$(=today())"}>} Fechamento)
Perfect Vegar!
You are the best...