Select Middle File Based on Creation Date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
