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))//

Greetings All,

in the following code am using Microsoft.VisualBasic in my C# program. with out using Microsoft.VisualBasic can any one help me to give the complete equvalent code in C#

Microsoft.VisualBasic.FirstDayOfWeek z1 = 0;
DateTime dt1= DateTime.Now;
string strDayName = DateAndTime.WeekdayName(DateAndTime.Weekday(dt1,z1),false,z1).ToString();

Thanks
Tec

hai.. i'm trying to do the same thing using C++..
can anyone help me ? i'm juz a beginner.. tried so many things but nothing works..
Pleasssss...