correct the datediff function

[muddasirmunir]

i am using vb 6 , i had place two datepicker in form now i want to calcuate differcen of month in two date for this i used the function datediff

i had try it withh many syntax but getting error like

 datediff(mm,date1,date2) 
datediff(mmm,date1,date2)
datediff(month,date1,date2)
datediff("mm",date1,date2)
datediff("mmm",date1,date2)
datediff("month",date1,date2)
OR
datediff("month","date1",date2")

but always getting error invalid procedure called so what is the correct systax.

[debasisdas]

please find a realted article here.

[QVeen72]

Hi,

You need to assign it to some Integer:

Dim iMon As Integer
iMon = datediff("mm",D tp1.Value,dtp2. Value)

Regards
Veena