Find multiple rows with timestamp between 2 dynamic dates

[Tigris1990]

Hi,

 I have 2 data sets.

The first dataset consist of 2 dates and a legend.

Example: 

And the second one consist of KM and a timestamp.

My goal is to find all KM based on the timestamp that is after Start date and before End Date from the first workflow.

I tried, but I know it is a bit stupid method.

As you can see the timestamp is before the start date.

Is there a way of having a dynamic filter between those 2 dates to find all the timestamps? And would this join be the best method?

[binu_acs · Accepted solution]

@Tigris1990 One way of doing this 

[ShankerV]

Hi @Tigris1990 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @Tigris1990 

If you need the output to be combined in one single line like below.

Many thanks

Shanker V