How to get the sum of a field for a dynamic timeframe such as "last week"
I want to know how many pieces of a specific product I've sold "last week", "last month", or "the last 60 days". I'd like to have the corresponding database field be a calculation so that this value is right there and up to date everytime I look up a product - withouth having to manually adjust dates or functions.
So far, I've only found calculations for specific dates. Is FileMaker capable of adjusting dates in calculations dynamically?