Weekly schedule

[Drexler]

Hi Everyone, newbie here. 

I am working a workflow that is schedule every Monday and the input files were saved every Friday and Saturday of previous week, for example the run date is 1/29 and the input files are saved 1/26 and 1/27. Please assist how should I enter the formula to make sure that the wf will capture if the input files are not updated

 

. See current formula I am using, unfortunately, the error shows dependency file is not updated

[Raj]

use current Date =Datetimetoday()
while you are checking the Directory check the latest date of Update
if Latest date of Update >= datetimeadd([current date],-3,"days") then true else False endif.

Just an overview
this should work.

[gawa]

hi @Drexler 

DateTimeDiff() function can be used.

Attached WF is to put a flag if "LastWrite Time" is within 7 days or not. You can change parameter "7" as needed.