All lookup methods can have a set of modifiers appended at the end. These modifiers add additional advanced functionality to the lookup method.
The modifiers are:

  • .History(<number>,<date_period>)
  • .Date(<field_name>)

History:

The history modifier returns registrations for a previous date period. The available date periods are Day, Week, Month, Year.

Your formula looks like this if you wish to get the number of all items sold from two weeks ago:

Need a specific example? Please check out our article on the History Modifier here.

Date:

Instead of the regular date field, use the provided date field for the lookup:

  • .Date(<field_name>)

This is smart if you wish to count e.g. orders from the 'Close Date', and not from the regular date field in your data source (e.g. the registration date/created date):

Example of a date field in a data source.

Simply type in the name of the date field from your data source that you wish to add to your formula:

Related articles:
How to use the .History Modifier in formula editing (full article).
Lookup Functions.

Did this answer your question?