Select Middle File Based on Creation Date

cobo1981

Hello,

I am trying to pull three different files from the same folder based on their creation date but have difficulty pulling the file with the middle creation date. In the example below, I can pull Dec 21st & Dec 23rd without a problem, but Dec 22nd comes back with both the 22nd and 23rd information on it. How can I only pull Dec 22nd?

Developer

Accepted answers

Felipe_Ribeir0

Hi @cobo1981

One way that you can try, sample the first 2 and then the last 1:

All comments

Felipe_Ribeir0

Hi @cobo1981

One way that you can try, sample the first 2 and then the last 1:

kathleenmonks

Hi @cobo1981,

You could use a Record ID tool and then a couple filter tools to get records 1,2,3 in separate streams instead of using the sample tool.

You can also just use one directory tool and one sort tool in order to reduce complexity in your workflow since they're all doing the same thing.

Let me know if this helps!

cobo1981

Yeah, I did it on my own after posting the question here. I used the same logic as you in your first comment. I think this might work, just have to test for any possible failures. I'll also try the Record ID tool; thanks for the suggestion.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703