different in days by number

[dortmund]

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?

[brown monkey]

datediff() function mate. cheers.

[dortmund]

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 ??

[brown monkey]

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

[Pirate]

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