3 Replies Latest reply on Feb 9, 2009 11:35 PM by PatrickHolzer

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

    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