[RESOLVED] Date difference

Hi everyone!:wave:

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:

VB Code:

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

There is a DateDiff() function.

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

VB Code:

Result = date2 - date1

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

Nooooooooooooooooooooooooo...

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

If you use:

VB Code:

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:

VB Code:

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

I get an "Argument not optional" error.

Can anyone help? :confused:

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

even this gives a mismatch error:

VB Code:

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

Plz help me!:cry:

I've got it!! :D :D :D

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

VB Code:

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

Tnx for the tip about DateDiff...I'll reputate at once! :D ;)

Quote:

---

Originally Posted by cyber_alex

If you use:

VB Code:

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).

Quote:

---

Originally Posted by RhinoBull

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.