Task:

Short Description: To find the files in a particular directory for the previous day, sort them by date and time and e-mail it across to a particular id.

And the time is divided into eight fields and based on the time the respective field should be updated with the flag 1.

Eight fields look like (12 to 15, 15 to 18, 18 to 21, 21 to 24,
00 to 03, 03 to 06, 06 to 09 and 09 to 12)

And finally the total column should be updated with the no of files that belong to the same type.

Please find the attached excel sheet. Needs to send the attachment in this format to users.

Thanks in advance,
Venkatesh.

Attached Files

Core Dumps 05 Nov Example.xls (34.5 KB, 26 views)