How to get the oldest file created from the folder

[Krithi1]

Hi,

I am using the following code to get the latest file from a folder. Now, my requirement is to get the oldest file from the list, instead of the latest one. I don’t see the OrderByAscending function to use. Can someone help please?

Directory.GetFiles(“Path”,“ORCH"+".xlsx”).OrderByDescending(Function(d) New FileInfo(d).LastWriteTime).Where(Function(n) not path.GetFileName(n).Contains(“~$”))(0)

[kumar.varun2 (Varun Kumar)]

@Krithi1

Just use OrderBy, it will order in ascending order

Directory.GetFiles("Path","ORCH"+".xlsx”).OrderBy(Function (d) New FileInfo(d).LastWriteTime).Where(Function (n) Not Path.GetFileName(n).Contains("~$")).First

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @Krithi1,

This looks like a duplicate post.
There are numerous solved threads (mostly by @prasath17) for similar questions :

Studio

• How to get the first file stored in a folder? - Help / Activities - UiPath Community Forum

• How to get latest downloaded file in a workflow or sequence? - Help / StudioX - UiPath Community Forum

• How can I get only files added today from a directory - Help / Activities - UiPath Community Forum

• How to get the first 4 files in a directory - Help / Studio - UiPath Community Forum

StudioX

• Find latest downloaded excel file, having random name, and open it - Help / StudioX - UiPath Community Forum

---

How to search?

Do use the search function (advanced search) in this forum. It is quite an accurate search.

Filtering to known forum members

[Sudharsan_Ka]

Hi @Krithi1

1. You will find show StudioX in Filters
   
2. Search for For each File
   
3. You can finf this activity and you can order by various options here