different in days by number

Hi,

What is the correct syntax to find the different in days by number?


Due Date : 31/7/2004
Date Return: 2/8/2004 which is =now()
No Of day : = 3 days << how to get this value?

datediff() function mate. cheers.

Quote:

---

Originally posted by brown monkey
datediff() function mate. cheers.

---

This is the code I use



txtFine.Text = CStr(DateDiff(DateInterval.Day, CDate(txtDueDate.Text), CDate(Now())))


Where txtDueDate.Text = 1/8/04
And the result is 207 ??

it's month/day/year mate. not day/month/year. 207 alright. :) from jan/one/two thousand four.

You can also use the pure .NET way by using TimeSpan class .