Okay, I parsed out the date from a file which has NO relation with the date formats in VBA or whatever.
Tue Aug 24 21:00:00 2004 <-- taken from a data file, and inserted into the MS Access db table (that is only one of the files in the record)
All I want to know is if there is a format in VBA where I can employ the DAY(mon,tue,etc) and TIME to perform the DateDiff() and return the number of seconds (just like my previous post as I am getting a type mismatch error due to my formatting)
You asked before why I didnt use the date as it is, well it doesn't work as I get the same error.
Namely,
DateDiff("s", "Tue Aug 24 2004 6:00 PM", "Wed Aug 25 2004 1:00 AM")