datediff

[cjkenworthy]

I want to calculate the difference between two dates using the following code:

dim cancel_date, date_now, difference
cancel_date = NGN.Fields.Item("date_held&quot.Value
date_now = Date()

difference = DateDiff("d", cancel_sale, date_now)

if difference > 7 then
response.write("Yes&quot
else
response.write("No&quot
end if

Problem is, given

'cancel_date' has a value of 09/12/02
'date_now' has a value of 11/12/02

difference is '37601' for some strange reason.

Any ideas?

 

[onpnt]

you have them backwards.
don't feel bad I used to do it all the time
try

difference = DateDiff("d", date_now,cancel_sale)
you also don't need the var declaration for now. just use now in the datediff function

Just a suggestion: faq183-874

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com