I didn't get your question. I have prepared a script where it does finding the files in a directory for the previous day and e-mail it across to the respective users.

But i need to prepare a script where based upon time field the flag should be update with 1. Explained clearly this point. Please help.

Thanks,
Venkatesh.