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
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.
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.