Count records from only the last 90 Days

[Doors1980]

I can easily count all records using:

CountRows(Search(LLL, "Kerry", "Title"))

How do I search the same data but return items only from the last 90 days?

Thanks, 

[BitLord69]

Hi!

You have two options: either you change your Search to maybe a Filter and select your dates there, or you do a CountIf instead. It will look something like this:

CountIf(LLL, DateColumn >= DateAdd(Today(), -90))

You have to change the name of the column, and if it's not a date value already (meaning if the date as stored as text), you have to use DateValue to make it into a date.

Good luck!

[Doors1980]

Thanks @BitLord69 , how would I add the 90 days into a filter formula? (as I also need to filter by another field, not just by the 90 days)

[Anonymous · Accepted solution]

Hi @Doors1980

If you want to Count all rows that match few criteria I recommend using something like this:

CountRows(
  Filter(
    LLL,
    DateColumn >= DateAdd(Today(), -90),
    Title = "Kerry"
  )
)

This will only count rows that have Kerry in Title and the date column which is up to 90 days behind today.

[Doors1980]

Perfect @Anonymous , cheers for the help.  I'll get the hang of this one of these days.