How to find the excel files that were modified by one week ago

[Chris-Yiwei (Ji)]

dear all，

I have some Excel files in a folder, some of these Excel files were modified within one week(depends on nowdate), some of these files were modified one week ago, how could I find the excel files were modified one week ago in this folder? anybody could give me some demo code ?  thanks a lot in advance.

[Palaniyappan (Palaniyappan P)]

Hi
Kindly have a view on this thread

Get file from a directory with specific modified date

You can use modified date or date in filename, but date in filename would require some date extraction and conversions in order to compare with your date you want to look at. What if you simply just pulled in the files that match a keyword pattern with a wildcard, then you can either compare the WriteTime with a .Where() or using a For each with an If activity inside. It might look like this: Assign dateSearch = "10/20/2018" Assign filePattern = "Report 52 - SDLC Cap Report Summary*.xlsx" As…

Cheers @Chris-Yiwei

[Chris-Yiwei (Ji)]

dear Palaniyappan,

thanks a lot for your reply. could you give me some demo .xaml code? I feel confused.

[Palaniyappan (Palaniyappan P)]

Fine
May I know at which spot we got stuck with the above mentioned thread
@Chris-Yiwei

[Chris-Yiwei (Ji)]

i could get the (write line) the modified date of each files in a folder, use File.GetLastWriteTime(path).ToString. how compare these modifed date with nowdate, if one week ago , then do next task? of course , nowdate is a variable , it depends on system time .

[Palaniyappan (Palaniyappan P)]

@Chris-Yiwei

if one week ago , then do next task?

To check with one week ago use directly this term in the right of CONDITIONAL operator >
Now.AddDays(-7)

Cheers @Chris-Yiwei