Calculating Date Differences with DateDiff

Thanks a lot for this article.
I've been building an extensive online payment platform and had been having problems with the transaction history. your article just sorted this out. cheers,
joel
jomeike@mail.com

date diff function

I found your article of interest, there is only one problem that I need to address rather than going in to lengthy code.

DiffADate = "Years old = " & DateDiff("yyyy", 24/09/1991, [16/09/2003])

[assume this is the now system Date]

In theory this should return "Years Old = 11" it returns 12, please advise

You are finding the difference between the years which is 12.

Hi,

I am using C#. I would like to calculate the difference between 2 dates and the result is expected to be in No. of Days. Refer to the below example

DateTime dt1 = dr[REC_DATE_COL]; //01/07/2005
DateTime dt2 = dr[DUE_DATE_COL]; //05/07/2005

TimeSpan ts1 = dt1 - dt2;
Messagebox.Show(ts1.Days.ToString()); //Result should be 4 Days

The result shown above in the form of messagebox is returning the result as 120.

Can anyone suggest anything. I'll greatly appreciate it.

Thanks in advance.

Regards.

Hi opels,

U try this way. The code is in C#


For Example

DateTime dt1= new DateTime(2005,7,1); //01/07/2005
DateTime dt2= new DateTime(2005,7,5); //05/07/2005


Messagebox.Show(dt2.Subtract(dt1).Days)// the result shows 4 as u would expect

Murali


<Added>

Messagebox.Show(Convert.ToString(dt2.Subtract(dt1).Days))//