Comparing Last Modified Date of a file to System Date

[as0125]

I'd like to get the last modified date of a file and compare it to the system date. So far, I've only been able to come up with FileDateTime and Now functions, which includes the time. But I don't want the time included. Are there any other functions that I can use or is there a way for me to trim off the time?

Dim FileDate, Today
FileDate = FileDateTime(Source)
Today = Now

 

[ETID]

today" may be a reserve word

try: to_day = date$

 

[as0125]

Thanks -- but I figured it out. This is how to format the date.

'Date formatted to m/d/yyyy
FileDate2 = Format(FileDate1, "Short Date")
Today = Format(Now, "Short Date")

By the way, "Today" is not a reserved word.

 

[ETID]

but,..Today is an excel function, i.e. =today()...so as a rule, I tend to stay away from integrated function names in macros, it makes things easier to trouble shoot among other things.

 

[as0125]

Okay -- thanks for the tip.