Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by brentChch
-
Problems with date time formats
Hi Thanks for your replies. I just put this into the code: LastModified = file.DateLastModified If instr(LastModified, "p.m.") <> 0 then LastModified = left(LastModified, len(LastModified) - 4) & "pm" elseif instr(LastModified, "a.m.") <> 0 then LastModified = left(LastModified... -
Problems with date time formats
Hi I am trying to write a program to get a list of log files and sort by the .DateLastModified then open the most recent and search for text, then the next oldest file, etc. I thought it would be easiest to insert into a MS SQL table and then query the table and ORDER BY Modified DESC. I am...
