Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to test the modification time of a file to see whether it is more than
20 hours old. So far I have: dim dteFileMod as Date dim dteNow as Date dim dteDiff as Date 'Get the date/time properties of the file dteFileMod = FileDateTime(strFilename) 'Get date/time now dteNow = Now 'As long as it is less than 20 hours old allow it to be used dteDiff = dteFileMod - dteNow I thought that a simple subtraction would work, but it hasnt. If I do a debug print after it has run I get the following values: dteDiff = 24/12/1899 22:25:06 dteFileMod = 14/09/2006 15:55:19 dteNow = 21/09/2006 14:20:25 Will someone please explain date/time subtraction in VB; or suggest an easier way? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modification Time Update | Excel Worksheet Functions | |||
Modification of a .CSV file | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Testing Time /Date stamps of Files | Excel Programming | |||
Testing Time /Date stamps of Files | Excel Programming |