Now is Date not todaydate. Also your code makes no sense to me, I am not
seeing the link between this code and your original request. What exactly
are you trying to do?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ina" <roberta.inalbon@gmail.com> wrote in message
news:1145751269.780368.43490@j33g2000cwa.googlegroups.com...
> thank you a log but I would like to use datediff between the first date
> and and now today but I have a strange result I do not undestand why
>
> Do While datedifferencee > 0
>
> currendatemonth = Month(currentdate)
> currentdateyear = Year(currentdate)
>
>
> difference = datediff("m", todaydate, currentdate)
>
> datedifferencee = CInt(difference)
>
>
> currentdate = DateSerial(Year(currentdate), Month(currentdate) + i, 0)
>
>
> currendatemonth = currendatemonth + 1
>
> Loop
>
> Ina
>