Count records since 7 days ago?

Table “Companies” is a list of companies.
Table “Posts” lists blog posts, and has a Date field.

They are linked related between Companies’ “Posts” field and Posts’ “Company” field. ie. Posts relate to companies.

On the Companies table, I am able to successfully show a “Total Posts” count of the number of corresponding posts, by adding a Count field for the Posts table.

However, how can I add another column to Companies which only counts those Posts whose Date fields fall within the last seven days?

tl&dr - How do I count the number of linked records whose date falls within the last seven days?

In your Count field, turn on the option to “only include linked records that match certain conditions”, and specify your date field “within the last week”.

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.