Weekly schedule

Question

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

Gawa · Answer

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.

1234612_gawa.yxzp

Raj · Answer

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.