Filtering in a date range different columns of dates

Question

Hi all!

I need to create a formula to sum the distance [Km] of some travels [Travel].

All these travels has 3 dates to identify it: the start date [Date Start], a checkpoint date [Date Middle] and an end date [Date End].

I want only to sum the distance of the travels which have at least one of the 3 dates included in the range shown at the end of the sample
[Date Start Evaluation] for the earliest date possible

[Date End Evaluation] for the latest date possible

How can I do it? Thank you very much

image.png

davidskaife · Answer

Hi @filipembribeiro

Here is one way of doing it:

I've made it so it should be dynamic as well - append the Evaluation dates onto the data and then using a Formula tool it compares to see if each date is within the evaluation parameters; returning True or False if any of the 3 dates match. Then it filters on true and sums the KM for these.

Sum based on dates.yxmd