I need to calculate the number of days between dates but
am not having much luck with the datediff function.
[snip]
vNumberofDays = DateDiff(d, vDate1, vDate2)

The first argument needs to be in quotes, i.e. "d".

HTH,
Merjet