Compare Date/Time Elapsed... [resolved]

[Mc Brain]

Can anyone show me how to compare a date and time (that are hardcoded) with the current date and time ?
And then show the elapsed time in seconds ?

Any help is greatly appreciated.

Try this:

Debug.print DateDiff("s", "04/18/2005 17:51", Now)

[dglienna]

Just convert the value and then compare it.

dim hardcoded as date
hardcoded = cdate("04/18/2005 17:51")
Debug.print DateDiff("s", hardcoded , Now)

[thegreatone]

Thanks for the help, i need a good look at the built in functions of VB6, nw where i can find any ?

[shragel]

MSDN.MICROSOFT.COm

[thegreatone]

Wow, i well and truly forgot about that one, lol

Plus, i think you had an arguement with Caps Lock there mate. lol
Thanks.

[moinkhan]

Just wondering Why can't you just use conditional operator to compare the dates?

If format("04/18/2005 17:51","mm/dd/yyyy hh:mm") = format(now,"mm/dd/yyyy hh:mm") Then 
 
...... 
 
End If

[Mc Brain]

Just wondering Why can't you just use conditional operator to compare the dates?

If format("04/18/2005 17:51","mm/dd/yyyy hh:mm") = format(now,"mm/dd/yyyy hh:mm") Then 
 
...... 
 
End If

Because he said:

...
And then show the elapsed time in seconds ?...

So, if he needs the elapsed seconds... if ElapsedSeconds = 0 => they're the same. And you have the elapsed time already.

Besides... I would not EVER rely on MS Format function for dates. That function does not always answer correctly (according to the regional settings)

[moinkhan]

Because he said:

So, if he needs the elapsed seconds... if ElapsedSeconds = 0 => they're the same. And you have the elapsed time already.

Besides... I would not EVER rely on MS Format function for dates. That function does not always answer correctly (according to the regional settings)

well... I have experienced that CDate also sometimes formats the date WRONG... like.. takes it d/m/y sometimes.. rather than m/d/y maybe depending upon the regional settings... that's y I always like to format it first..