Dear GURUS,

First of all I am thankful for being patient with me. Let me explain in more detail:

Current will always have the filename with the latest "MMDDYYYY".
Archive will be having the last 6 MMDDYYYY for each of the filenames.

Whenever a file comes with a new MMDDYYYY then only you move the old file from CURRENT to ARCHIVE else you leave the old file in the CURRENT itself.

Say on August 1 is the first day. Both Current and Archive will be empty.
You are getting three files:
File1_extract_08012011.csv
BAXT_INV_08012011.csv
HMIA_CLS_08012011.csv

We will copy all the 3 file to Current folder.

Then next day Aug2, you are getting the following 3 files:
File1_extract_08022011.csv
BAXT_INV_08022011.csv
HMIA_CLS_08022011.csv

Now all the three files with 08012011 will be moved to ARCHIVE and the CURRENT will the 08022011 files.

Now on Aug3, we get only two files:
File1_extract_08032011.csv
BAXT_INV_08032011.csv

Now we should move only File1_extract_08022011.csv and BAXT_INV_08022011.csv to ARCHIVE and keep the HMIA_CLS_08022011.csv in the CURRENt folder. The latest 08032011 files will also be copied to CURRENT.

As of Aug3, ARCHIVE folder will have:

File1_extract_08012011.csv
BAXT_INV_08012011.csv
HMIA_CLS_08012011.csv
File1_extract_08022011.csv
BAXT_INV_08022011.csv

CURRENT folder will have:
File1_extract_08032011.csv
BAXT_INV_08032011.csv
HMIA_CLS_08022011.csv


This continues and at any point of time in future the ARCHIVE should have only the last 6 MMDDYYYY's.

Hope this gives a clear picture of what I am trying to do.

Thanks