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?

[Felipe_Ribeir0 · Accepted solution]

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.