Find Weekly File in Month Directory
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-02-19 01:47 AM
Suppose my feb month directory have 4 file below mention sequence.
XYZ 4 February.xls
XYZ 11 February.xls
XYZ 18 February.xls
XYZ 25 February.xls
my directory will only update on monday next file came in 4 march. only work on latest monday file as per latest, I'm working on 25 february file.I need logic how to find latest Monday file in current month directory?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-02-19 12:17 PM
Hi,
Assuming that file naming convention is always the same -> Use ""Get Files"" from File Management utility (Assuming that folder contains only above files) -> Use ""Sort Collection"" from Collection Manipulation utility (Descending order) -> first row is the one You are looking for.
It may be overcomplicated but this one was my first idea (without code stage).
Best regards
Michal
