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?

KM-workflow.yxmd

Preparation

Accepted answers

binu_acs

@Tigris1990 One way of doing this

KM-workflow.yxmd

All comments

binu_acs

@Tigris1990 One way of doing this

KM-workflow.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703