Compare dates

[gopi09_m]

Hi

User wants to look for a value in the files that are generated/modified in the last n days.
To be precsie i asked the user to provide me with the date so that i can look for the files that are geenrated after that date and copy them to a particular folder and then search for the value he wanted.

i know how to access the last modified date of a file
I want to know how do i compare the date user gives (MM/DD/YYYY) with the file last modified date ?

 

[AlphaFrog]

If the User's date is a text string, then try something like this...

If FileDateTime(strTheFile) >= DateValue(strUserDate) Then

 

[gopi09_m]

the above line of code gives me an error "file not found"

I modified it like below and it worked,
If DateValue(strTheFile) >= DateValue(strUserDate) Then

 

[AlphaFrog]

strTheFile was intended to be the full path and File name of the file you wanted to test its' modification date.

But if you've got it working, then that's what's important.