Quote:
Originally Posted by forumsupport  Hello,
May we please know the type of file operation(s) that you need to perform with files whose 'Modified Date' = a specific date? |
Loop through files in folder
If 'modified date' > 30 days ago then
Exit Loop
End If
SQL SELECT using $FileName$
Loop through SQL
IF $Database Column(1)$ includes "xxxxx" then
SQL Insert
SQL Update
Email
End Loop
End Loop
This is only efficient if I can loop in order of 'modified date.' That way as soon as it encounters documents modified 30 days ago it will exit the loop. Thus it won't waste hours (literally) looping through files I don't want it to check.
Thanks!