I'm moving a text file from a network drive and inserting it into an access database. Is there anyway to say go and grab the file with the most recent modified date? They are adding a file each business day and naming it with the date example(textfile111302). I could use a date function and tell it to take today's date -1, but the problem is they do not create a file on weekends or holidays, so that would not work. Any suggestions?

It might seem obvious, but if they change the way they create the date part of the name to YYMMDD then you just need to select the "greatest of" the file names and this will always be the latest date. No date conversion is needed, they just need to remember the zeros in front of single digit days or months. As a completely irrelevant aside, I've often wondered why American dates are presented MMDDYY. Here in the UK the are DDMMYY, which seems a more logical sequence of increasing time period. The difference can create havoc when using American data or formats here - is 5/6/02 the fifth of June or the sixth of May? Anyway, I hope the above suggestion helps.

that's why i prefer the computer's default. YYYYMMDD. Decreasing imortance. iluvit.