Question:
Do you know an algorithm that will give me the elapsed time froma beginning and end date/times (day:hh:mm:ss)?
Answer:
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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
