Read files based on date

Help Studio
, ,
1

Hi ,

I want to read files(excel,txt,folders) in some time frame like past 15 days or past30 days .
I am not able to build logic how to do it with time frame.

Thanks
Pankaj

2

e.g.

arrFilesFI  = 
new DirectoryInfo(YourDirPath).GetFiles().Where(Function (x) x.CreationTime.Date < Now.Addays(-15).Date).toArray

Or
arrFilePaths =

arrFilesFI  = 
new DirectoryInfo(YourDirPath).GetFiles().Where(Function (x) x.CreationTime.Date < Now.Addays(-15).Date).Select(Function (f) f.FullName).toArray
3

Thanks will try to implement this.

4

Hi

Hope the below expression would help you resolve this

Use a assign activity like this

arr_filepaths = Directory.GetFiles(“yourFolderPath”).Where(Function(x)CDate(new System.IO.FileInfo(x).LastWriteTime.Date)>=Now.AddDays(-15) and CDate(new System.IO.FileInfo(x).LastWriteTime.Date)<=Now).ToArray

Cheers @pankajdhane

1 Like
5

Is there any further queries on this topic
@pankajdhane

6

No . Thanks

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.