DateDiff Problem

Hi.

I want to determine how long a month is, but when I do this

Code:

---


strLeft = 8/31/2003
varMonthLength = DateDiff("d", CDate(strLeft), DateAdd("m", 1, CDate(strLeft)))

---

I get 30 instead of 31, what can cause that to happen?, and how I can get the accurate number?

Thanks in advance.

Um, hehehe, my mistake, I know what is happening :)

Tell us .. what is happening!!!

Try this:

VB Code:

strLeft = "8/31/2003"
varMonthLength  = Day(DateSerial(Year(CDate(strLeft)), Month(CDate(strLeft)) + 1, 0))

Diego.

It is just because september (month number 9) has only 30 days. If you add 1 month to 31-8-2003 you get 30-9-2003