Filter for next available day

Hi All,

I have a date column as follows:

I am looking to filter date for day after tomorrow (dynamic) but since here 04/09/2020 is not present it should look at next day and if that is also not available then next day and so on. So in this case I should get 04/13/2020.

I am trying to use this formula:

Let me know if this is wrong or if there is any other way to do this. Thank you!

Help

Expression

Accepted answers

BrandonB

What about a filter tool that says [Settlement Date] > DateTimeAdd(DateTimeNow(), 1, "Days") and then a sample tool afterwords where it picks N number of records with N=1. If the dates are already sorted in order the filter will only pass through the days after tomorrow and then the sample tool will only pass through the next available record.

grossal

I think Brandon means something like this:

You first reset your filter to what he originally suggested:

And than use a sample + group by option to always get the first per ID.

I'll attach your modified workflow.

Best

Alex

filterday.yxmd

All comments

BrandonB

agrawaluk

Hey Brandon,

Thanks for your response. This would work, but I missed a major detail to add to my problem, there is another column "ID" which has the same dates. So in this case sample wouldn't work exactly.

Sample data of what I am looking at

ID	Date
1	4/7/2020
1	4/8/2020
1	4/13/2020
1	4/14/2020
1	4/15/2020
2	4/7/2020
2	4/8/2020
2	4/13/2020
2	4/14/2020
2	4/15/2020

What I want the filter to do in this case:

1	4/13/2020
2	4/13/2020

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703