I need to know the best approach to determine if a file or files exist for a given date. The following naming convention is used for the files:
Am031700a
Am031700b
Pm031700a

For any given day, there can be numerous Am and Pm files. The last letter of the file name distinguishes the files. The user will be prompted to enter a date range. The program will then need to search the specified directory for all files for that day. How can I look at every single file in the directory and compare the date portion of the filename to the date range the user entered? I know how to use the FILE() function. I need a way that is going to allow me to scan the entire directory and compare each file name.

Thanks in advance for your assistance.