Formula tool to extract input files that are in a folder that end with yesterday date

[APIUserOpsGiri]

I have to extract files inside a folder that ends with yesterday's date For example folder name is "abcd_2023-02-06".

The suffix of the file needs to have yesterday's date in this format "_YYYYMMDD" and I need to extract all the files inside that folder.

[binuacs]

@APIUserOpsGiri One way of doing this is by checking the included subdirectories option in the directory tool then filter out the directory name the file name

[ShankerV]

Hi @APIUserOpsGiri 

Please find the expected output.

All the files in the directory will be read. For the use case I have created only one file to explain.

Many thanks

Shanker V

[APIUserOpsGiri]

This gets me inside the directory, but I want files inside the directory, how can I make it get the files inside it???

[binuacs]

@APIUserOpsGiri the below filter condition will first check for the directory then the second condition will filter the file with yesterday's

//extract the directory with the name YYYY-MM-DD
Contains([Directory], DateTimeFormat(DateTimeAdd(DateTimeToday(),0,'day'),'%Y-%m-%d'))

AND

//extract the files with the name YYYYMMDD

Contains([FileName], DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,'day'),'%Y%m%d'))

date in the format YYYYMMDD format