How many rows I have between two dates

[brunolelli87]

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 

[Vegar · Accepted solution]

Try this:

count({<Date = {">=$(=addyears(today(),-1))<$(=today())"}>} Fechamento)

[brunolelli87]

Perfect Vegar!

You are the best...