AnsweredAssumed Answered

How to get the sum of a field for a dynamic timeframe such as "last week"

Question asked by PatrickHolzer on Feb 6, 2009
Latest reply on Feb 9, 2009 by PatrickHolzer

Title

How to get the sum of a field for a dynamic timeframe such as "last week"

Post

Hi,

 

My goal:

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.

 

Trouble:

So far, I've only found calculations for specific dates. Is FileMaker capable of adjusting dates in calculations dynamically?

 

Thanks!

- Patrick

Outcomes