Do you know an algorithm that will give me the elapsed time froma beginning and end date/times (day:hh:mm:ss)?
The DateDiff function, included with VB 3 and 4, will give you the difference between two variants (VB3) or variables of type Date (VB4). I’ve used it quite a few times to determine if a resource for Ask the VB Pro is newer than a given date. Here is the line of code I use to return a boolean value:
IsResourceNew = DateDiff(“d”, vNewDate, CVar(rsLinks(“LinkAddedDate”))) >= 0This gives me the number of days vNewDate is before rsLinks(“LinkAddedDate”), both of which are of type Date.