cancel
Showing results for 
Search instead for 
Did you mean: 

Find Weekly File in Month Directory

AshutoshRai
Level 3
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

MichalSzumski
Level 6
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