Use VB DateDiff function in C#

[andyoye]

I have two date fields(startDat e, endDate) in a form and I want to
calculate number of days between startDate & endDate.

Thanks

[Alberto Poblacion]

"andyoye" <an*****@nospam .comwrote in message
news:O4******** ******@TK2MSFTN GP05.phx.gbl...

>I have two date fields(startDat e, endDate) in a form and I want to
calculate number of days between startDate & endDate.

int days = ((TimeSpan)(end Date-startDate)).Day s;

[Cor Ligthert[MVP]]

Hi Andy,

DateDiff in VB is a little bit from pre history.

This it can be in VB 2008
\\\
Dim EndDate = DateTime.Now
Dim StartDate = Now.AddDays(-3)
Dim days = EndDate - StartDate
MessageBox.Show (days.Days.ToSt ring)
///

This it can be in C# 2008
\\\\
var EndDate = DateTime.Now;
var StartDate = DateTime.Now.Ad dDays(-3);
var days = EndDate - StartDate;
MessageBox.Show (days.Days.ToSt ring());
///

I real don't see much differences.

The VB code only in this case to show that the question is a little bit
strange.

Cor
"andyoye" <an*****@nospam .comschreef in bericht
news:O4******** ******@TK2MSFTN GP05.phx.gbl...

>I have two date fields(startDat e, endDate) in a form and I want to
calculate number of days between startDate & endDate.

Thanks

[andyoye]

startDate field value is 10-01-09
endDate field value is 10-05-09

How can I get 4 .....(endDate-startDate)

"Cor Ligthert[MVP]" <no************ @planet.nlwrote in message
news:um******** ******@TK2MSFTN GP05.phx.gbl...

Hi Andy,

DateDiff in VB is a little bit from pre history.

This it can be in VB 2008
\\\
Dim EndDate = DateTime.Now
Dim StartDate = Now.AddDays(-3)
Dim days = EndDate - StartDate
MessageBox.Show (days.Days.ToSt ring)
///

This it can be in C# 2008
\\\\
var EndDate = DateTime.Now;
var StartDate = DateTime.Now.Ad dDays(-3);
var days = EndDate - StartDate;
MessageBox.Show (days.Days.ToSt ring());
///

I real don't see much differences.

The VB code only in this case to show that the question is a little bit
strange.

Cor
"andyoye" <an*****@nospam .comschreef in bericht
news:O4******** ******@TK2MSFTN GP05.phx.gbl...

>>I have two date fields(startDat e, endDate) in a form and I want to
calculate number of days between startDate & endDate.

Thanks

[Jeff Johnson]

"andyoye" <an*****@nospam .comwrote in message
news:ek******** ******@TK2MSFTN GP06.phx.gbl...

startDate field value is 10-01-09
endDate field value is 10-05-09

How can I get 4 .....(endDate-startDate)

Alberto gave you the answer.

[andyoye]

Below is smaple code from my form

{

1: XPathNavigator docFM = this.CreateNavi gator();

2: string date_form = docFM.SelectSin gleNode("/my:myFields/my:startDate",
this.NamespaceM anager).Value;

3: XPathNavigator docFN = this.CreateNavi gator();

4: string date_to = docFN.SelectSin gleNode("/my:myFields/my:startTime",
this.NamespaceM anager).Value;

5: DateTime startDate = Convert.ToDateT ime(date_frorm) ;

6: DateTime endDate = Convert.ToDateT ime(date_to);

7: TimeSpan dateDifference = endDate.Subtrac t(startDate);

8: int days = dateDifference. Days;

9: string daysString = days.ToString() ;

10: XPathNavigator dateDiffTextBox Value =
this.CreateNavi gator().SelectS ingleNode("/my:myFields/my:dateDiff",
this.NamespaceM anager);

11: dateDiffTextBox Value.SetValue( daysString);

}

I get
"String was not recognized as a valid DateTime." at line 6
"When convertin a string to DateTime, parse the string to take the date
before putting each variable into the DateTime object"

thx

"Jeff Johnson" <i.***@enough.s pamwrote in message
news:ei******** ******@TK2MSFTN GP06.phx.gbl...

"andyoye" <an*****@nospam .comwrote in message
news:ek******** ******@TK2MSFTN GP06.phx.gbl...

>startDate field value is 10-01-09
endDate field value is 10-05-09

How can I get 4 .....(endDate-startDate)

Alberto gave you the answer.

[Cor Ligthert[MVP]]

Jeff,

Because this is in my answering thread.

I am curious, what is beside that I use C# 2008 code and Alberto C# 2003
code in your idea the difference between those two answers. Don't understand
me wrong, nothing wrong with Alberto its code, however you give the
impression there is something wrong with mine?

Cor

"Jeff Johnson" <i.***@enough.s pamschreef in bericht
news:ei******** ******@TK2MSFTN GP06.phx.gbl...

"andyoye" <an*****@nospam .comwrote in message
news:ek******** ******@TK2MSFTN GP06.phx.gbl...

>startDate field value is 10-01-09
endDate field value is 10-05-09

How can I get 4 .....(endDate-startDate)

Alberto gave you the answer.

[andyoye]

I got it guys, I was passing a wrong var

thanks all.. you all rocks!!!
"andyoye" <an*****@nospam .comwrote in message
news:Op******** ******@TK2MSFTN GP06.phx.gbl...

Below is smaple code from my form

{

1: XPathNavigator docFM = this.CreateNavi gator();

2: string date_form = docFM.SelectSin gleNode("/my:myFields/my:startDate",
this.NamespaceM anager).Value;

3: XPathNavigator docFN = this.CreateNavi gator();

4: string date_to = docFN.SelectSin gleNode("/my:myFields/my:startTime",
this.NamespaceM anager).Value;

5: DateTime startDate = Convert.ToDateT ime(date_frorm) ;

6: DateTime endDate = Convert.ToDateT ime(date_to);

7: TimeSpan dateDifference = endDate.Subtrac t(startDate);

8: int days = dateDifference. Days;

9: string daysString = days.ToString() ;

10: XPathNavigator dateDiffTextBox Value =
this.CreateNavi gator().SelectS ingleNode("/my:myFields/my:dateDiff",
this.NamespaceM anager);

11: dateDiffTextBox Value.SetValue( daysString);

}

I get
"String was not recognized as a valid DateTime." at line 6
"When convertin a string to DateTime, parse the string to take the date
before putting each variable into the DateTime object"

thx

"Jeff Johnson" <i.***@enough.s pamwrote in message
news:ei******** ******@TK2MSFTN GP06.phx.gbl...

>"andyoye" <an*****@nospam .comwrote in message
news:ek******* *******@TK2MSFT NGP06.phx.gbl.. .

>>startDate field value is 10-01-09
endDate field value is 10-05-09

How can I get 4 .....(endDate-startDate)

Alberto gave you the answer.

[Jeff Johnson]

"Cor Ligthert[MVP]" <no************ @planet.nlwrote in message
news:C4******** *************** ***********@mic rosoft.com...

Jeff,

Because this is in my answering thread.

I am curious, what is beside that I use C# 2008 code and Alberto C# 2003
code in your idea the difference between those two answers. Don't
understand me wrong, nothing wrong with Alberto its code, however you give
the impression there is something wrong with mine?

Wait, are you asking me why I responded the way I did? If so, I was simply
telling andyoye that he was asking for an answer yet again when Alberto had
already given him the answer. In other words, "Pay attention: you've already
been told!"

[andyoye]

I already said: You ALL Rocks, thanks.

How about getting minutes difference? I mod the days code

TimeSpan timeDifference = endTime.Subtrac t(startTime);

int hours = timeDifference. Hours;

string hoursString = hours.ToString( );

Now I do get hours but not minutes.

"Jeff Johnson" <i.***@enough.s pamwrote in message
news:eg******** ******@TK2MSFTN GP04.phx.gbl...

"Cor Ligthert[MVP]" <no************ @planet.nlwrote in message
news:C4******** *************** ***********@mic rosoft.com...

>Jeff,

Because this is in my answering thread.

I am curious, what is beside that I use C# 2008 code and Alberto C# 2003
code in your idea the difference between those two answers. Don't
understand me wrong, nothing wrong with Alberto its code, however you
give the impression there is something wrong with mine?

Wait, are you asking me why I responded the way I did? If so, I was simply
telling andyoye that he was asking for an answer yet again when Alberto
had already given him the answer. In other words, "Pay attention: you've
already been told!"