hello all
I have a problem with Datediff function that i would be very happy if anyone can help me.
can we write such code for calculating datediff of 2 elements in recordset and set the returned value for another element of recordset:
<%rs.movefirst()
        while not rs.eof
        rs("a")=datediff(rs("b"),rs("c"))
        rs.movenext()
        wend%>
thank you

The problem with your syntax is that datediff requires 3 parameters:
The format of difference, and the two dates
such as DateDiff("d", Rs("b"), Rs("c"))
check this out, it should give you the answer you need:
http://www.w3schools.com/vbscript/func_datediff.asp

And remember - Google is your friend:
http://www.google.com.au/search?hl=e...datediff&meta=
Try it some time.



I am a loud man with a very large hat. This means I am in charge