Subtracting 2 dates which are strings

[Themuppeteer]

Hi,
I have a recordset containing 2 fields
i.g. '11 apr 2001 16:38:46:457 ' and
'11 apr 2001 16:39:46:487'

and I want to know how many time there is between them.
I know I can write a complete function to do this (which would be a lot of work), but before I start doing that, I would like to know if there isn't some sort of build in function that can convert these date-time fields to Idono, an integer or somthing ,so i can subtract them easily and save me a lot of time/work.

Thanks,
The Muppeteer

 

[bburnell]

Hi,
To use these functions in Win32 API, you will have to convert the string to the "systemtime" or "filetime" format and then compare them. Look at these links for more information...

http://www.vbapi.com/ref/g/getdateformat.html

http://www.vbapi.com/ref/g/gettimeformat.html

http://www.vbapi.com/ref/s/systemtime.html

http://www.vbapi.com/ref/s/systemtimetofiletime.html

http://www.vbapi.com/ref/c/comparefiletime.html

Honestly,
you should look up code that someone else has already written and do that or write your own. Here is one to start you on your way:

http://www.planetsourcecode.com/xq/ASP/txtCodeId.22125/lngWId.1/qx/vb/scripts/ShowCode.htm.

Systemtime and filetime can be very confusing and lots of API coding.
I hope this helps!
Brett Please visit my websites!

http://www.smsforce.com

http://www.goodguyz.com

 

[Themuppeteer]

Thnxs smsforce,
I'll see in to it!

The Muppeteer.

 

[MatsHulten]

Hmmm... Why not just use DateAdd() function?

-Mats Hulten

 

[MichaelRed]

DateDiff("interval", Start, End)

interval ~ ["m" (Month) | "d" (Day) | "h" (Hour) | "n" (Minute) | "s" (Second)]

Start and end are valid dates.
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over