Help

Sum of values between two specific dates

Topic Labels: Formulas
1635 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DTO_SCMA
4 - Data Explorer
4 - Data Explorer

Hello - I’m looking to do a formula that counts the number of records between two specific dates.

Using the count function, I see lots of options for dates where it’s within the last week, month, etc. but nothing for a specific date range.

1 Reply 1

Welcome to the community, @DTO_SCMA! :grinning_face_with_big_eyes: A formula won’t work for this because formulas only operate on the field values in a given record; i.e. the formula’s output for a given record will be based on that record only.

One way to get the count would be to apply a two-part filter: the first part filtering records where the date is after (or is on or after, depending on your needs) your desired start date, and the second using the AND operator to filter records where the date is before (or is on or before) your desired end date. After the records are filtered, you’ll see a record count in the summary bar, below the primary field.