Check if there is file with todays date

Help Studio
1

Hi,
I have a folder with excel files created every day and I have to check if there is file from today, if not, then send mail. Files are recognised by name containing “DS”. Tried with flagBool = True but not working, it is always showing that it is false.

2

You need to provide more info, like what the filenames look like.

3

Hi @markosc

What was the date format in the file be like…

thanks

4

first assign variable with date and put as now.date
use activity path exists and select as file category
in filename section, pass it as “your filename”+ datevariable
if it returns true, your file exists else your file not exists

5

Here is an example of a folder. I have to check if there is file with date modified equal to now.date, if there is not, send an email.

image
image788×143 4.18 KB

6

the dates are of course different (made every day) this is just an example

7

Hi @markosc

Can we check the date modified and based on that decide whether it is created today or not

Thank you,
Prashant

8

I need to check if there exists a file with date modified = today

9

@markosc - please check this post

This has the code you are looking for.

10

And how do I then chek if there is not - send mail?

11

Hi @markosc
Modifying @prasath17 code a little to get it matched for your case

Directory.GetFiles(“C:\Users\giris\Desktop”).Where(Function(x) New FileInfo(x).LastWriteTime.Date = DateTime.Today.Date and Path.GetFileName(x).Contains(“DS”)).Count>0 use this as if condition to check if there are files as per your criteria or not

3 Likes
12

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