Get latest file based on creation time

[Dinesh_Babu_S]

Hello all.
I am trying to get the latest file and using the below code.

new DirectoryInfo(“C:\Users\Dinesh\Documents\UiPath\Excel_Automation\Input\Log”).GetFiles().OrderByDescending(Function(f) f.LastWriteTime).First()

But I am not getting the wrong file.

I am expecting the file 20230206_203506_SRC_PARK_ACC_FV60_Result.log from the above screenshot.

[Gokul001 (Gokul Balaji)]

HI @Dinesh_Babu_S

Check out the expression

Directory.GetFiles("C:\Users\Dinesh\Documents\UiPath\Excel_Automation\Input\Log").[Select](Function(x) New FileInfo(x)).Where(Function(f) f.Extension.Equals(".txt")).OrderByDescending(Function(x) x.LastWriteTime).Take(1).ToArray()(0).ToString 

Regards
Gokul

[Dinesh_Babu_S]

Thank you for responding.
It didn’t work.

Directory.GetFiles(“SRC_Common\Log”).[Select](Function(x) New FileInfo(x)).Where(Function(f) f.Extension.Equals(“.txt”)).OrderByDescending(Function(x) x.LastWriteTime).Take(1).ToArray()(0)

I just removed .tostring to rectify the error.

[Gokul001 (Gokul Balaji)]

HI @Dinesh_Babu_S

Check the properties of the file

Regards
Gokul

[Dinesh_Babu_S]

Yes.

[Ashutosh.Gupta]

Hi Dinesh,

Please try ‘For each file in folder’ activity. In this activity update “ORDER BY” => “Create date oldest first”.

[Dinesh_Babu_S]

@Ashutosh.Gupta It worked ,thank you.