Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

File Modified Date Notification

RDF25087
8 - Asteroid

Hi -

 

I'm looking for a workflow that looks at the last modified date of a file and notifies me by email if it is the same date as the last time the workflow was ran.

 

I probably haven't explained that very well....

 

I have a file on a network drive that should be updated every week. I need a fail safe that notifies me if that file hasn't been updated.

 

Any ideas?

 

Thanks

RDF

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora

Hi @RDF25087 ,

 

Directory tool gives you the file information of a directory.

If you run the workflow every day, you can filter the file with the Last Write Time is after yesterday.

Then you can make it to a Table and send as Email.

 

Workflow

Yoshiro_Fujimori_0-1683197591769.png

 

Formula in Filter tool

[LastWriteTime] >= DateTimeAdd(DateTimeNow(),-1,"day")

 

Table output

Yoshiro_Fujimori_1-1683197814355.png

 

I hope this may be of some help.

Labels
Top Solution Authors