Select todays excel file from specific location

Help
1

Hi friends,
How to select only todays excel file from the specific location in uipath

Regards,

2

@Rup_1,

Try below one:

directory.GetFiles(“Folder path”,“*.xlsx”).Where(function(file) file.LastWriteTime.Date= DateTime.Now.Date).ToArray

3

@Rup_1
Will your file have the time stamp mentioned? or
You need to retrieve files based on created/modified date?

If your file has timestamp mentioned, then you can directly specify that in Get files as
Directory.GetFiles([FOLDER_PATH], "[TODAY+DATE].xlsx)

other wise, retrieve files as specified by @lakshman

4

Hi @Rup_1,

Refer the below workflow for selecting today’s file from a specific folder.

get recent file.xaml (8.6 KB)

You can refer these posts also

5

i want to pull the excel file of todays date dynamically…from a folder

6

can i get solution for this