[RESOLVED] Date difference

[cyber_alex]

Hi everyone!

I've read somewhere a code for getting the difference between two dates...can't remember it, does anyone know how to do?

For example; if you have one date (2006-05-04) and another date (2006-05-09) then the result should be 5.
Now this is an easy example that's very easy to build a code for like:

result = Right(date2, 2) - Right(date1, 2)

But this code that I've seen works even for dates that crosses months like 2006-05-28 and 2006-06-12.

The code I've seen was a built in function in VB...does anyone know what it's called?

Happy for help!

//Alex

[RhinoBull]

There is a DateDiff() function.

[bushmobile]

and if you want to calculate the days you can just subtract:

Result = date2 - date1

[alkatran]

Just remember that all dates are just numbers to the computer, and you can get that number by converting to a long, using CLNG()

[RhinoBull]

Nooooooooooooooooooooooooo...

Dates are stored as Double so converting it to Long may cause some problem(s), are you kidding ?

[cyber_alex]

If you use:

result = "2006-06-10" - Date

you get a mismatch error.

The DateDiff code doesn't either work for me...am I using it wrong?
If I write this:

result = DateDiff(, "2006-06-10", Date)

I get an "Argument not optional" error.

Can anyone help?

[cyber_alex]

That's right RhinoBull...got lots of errors trying that to.... what am I going to do!?!?

[cyber_alex]

even this gives a mismatch error:

MsgBox CDbl("2006-06-10") - CDbl(Date)

Plz help me!

[cyber_alex]

I've got it!!

The trick is that you have to declare the "future date" before using it:

Dim thedate As Date
thedate = "2006-06-10"
result = DateDiff("d", date, thedate)

Tnx for the tip about DateDiff...I'll reputate at once!

[RhinoBull]

If you use:

result = "2006-06-10" - Date

you get a mismatch error...

That's because first argument is string and second is date - you need to convert firt to date:

result = CDate("2006-06-10") - Date

But I still say DateDiff() is better (safer that is).

[alkatran]

Nooooooooooooooooooooooooo...

Dates are stored as Double so converting it to Long may cause some problem(s), are you kidding ?

Sorry, I meant you can get the number of days by converting to a long. Usually you don't want the hours, minutes and seconds.