Compare date only and find the difference

Question

Hi I have a string and say for ex: 30-10-2016 in a string. Now how can I compare this date with today's date only and find the difference. I am unable to use TimeSpan too because I 'm unable to get date only using datetime. Todays date would be 27-10-2016 I need to find the difference between these two dates 30-10-2016 - 27-10-2016.

Dipika · Answer

string strdt=31/10/2016; DateTime dt=DateTime.ParseExact(strdt dd/MM/yyyy CultureInfo.InvariantCulture); DateTime today = System.DateTime.Now; int days = Convert.ToInt32((dt-today).TotalDays); Console.WriteLine(days); Console.ReadLine();

Prakash Kumar · Answer

DateTimeFirstDate=Convert.ToDateTime( 30-10-2016 ); DateTimeSecondDate=DateTime.Today; TimeSpanFirstMethodDays=SecondDate-FirstDate; TimeSpanSecondMethodDays=SecondDate.Subtract(FirstDate); int ThirdMethodDays=Convert.ToInt16((SecondDate-FirstDate).TotalDays); Console.WriteLine(Method 1:  + FirstMethodDays.ToString()); Console.WriteLine(Method 2:  + SecondMethodDays.ToString()); Console.WriteLine(Method 3:  + ThirdMethodDays.ToString());

Bikesh Srivastava · Answer

Use like this .i have already done. using System; using System.Net.NetworkInformation; using System.Net; using System.Net.Sockets; using System.Text.RegularExpressions; namespace Example { class Program { static void Main() { string s1= WhenyouarewritingservercodeyoucanneverbesurewhattheIPaddressyouseeisrefereeingto.Infactsomeuserslikeitthisway. ; string s2= WhenyouarewrtingservercodeyucannnneverbesurewhattheIPaddressyouseeisreferingto.Infactsomeuserslikeitthisway ; string []tempArr1=s1.Split( '' ); string []tempArr2=s2.Split( '' ); int counter=0; for ( int i=0;i { if (tempArr1[i]!=tempArr2[i]) { Console.WriteLine(tempArr1[i]+  +tempArr2[i]); counter++; } } Console.WriteLine( TotalModifiedWord:: +counter); Console.ReadLine(); } } }

Ananth G · Answer

Vasanti answer is correct

Vignesh Kumar · Answer

I would want to do it in c#.

Dipika · Answer

select DATEDIFF(dayconvert(datetime'30-11-2016'104)getdate()) This will give you the difference in days If you want month or year replace day with month or year