FormatDateTime

[danmat46]

Morning all,

Got a issue with a expression. Basically using the "Scripting.FileSystemObject" I am trying to create an expression to say (Pseudo code)

If the folder time is >= Now() time -1 then
'This folder has been updated within the last hour
strColour="Green"
elseif the folder time is >=Now() time -3 then
'This folder has been updated within the last 3 hours
strColour="lightGreen"
end if

only problem is when you have a issue like

Folder date time = "22/01/08 23:05"
Now date time = "23/01/08 01:30"

Is 23:05 > 00:30 YES, WRONG!!

Any help with this would be grately received

Dan

 

[PHV]

Have a look at the DateDiff function:

http://msdn2.microsoft.com/en-us/library/xhtyw595(VS.85).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886