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?
Printable View
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.
This is the code I useQuote:
Originally posted by brown monkey
datediff() function mate. cheers.
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 .