devxlogo

Calculating Elapsed Time

Calculating Elapsed Time

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”))) >= 0
This gives me the number of days vNewDate is before rsLinks(“LinkAddedDate”), both of which are of type Date.

devx-admin

Share the Post: