How to find number of days from two string type dates?

Question

I have two text box dates (8/11/2014) and (9/11/2014). I want to find the number of days between these two dates. I am getting some string error message. Please help me..

Convert them to proper DateTime values, then subtract one from the other. — Lasse V. Karlsen, Nov 06 '14 at 13:29
Can you post the code along with the error message? My psychic ability is playing up today. — Matthew Watson, Nov 06 '14 at 13:29
@Lasse V. Karlsen, If you dont mind please let me know how to convert these string dates into datetime value? — Dwane Marsh, Nov 06 '14 at 13:31
@DwaneMarsh: http://msdn.microsoft.com/en-us/library/cc165448.aspx Seriously, not to sound snarky here, but at least *try* Google. — David, Nov 06 '14 at 13:33
eh, I could understand someone new to programming not knowing how to research libraries. You gotta learn how to learn. — Jonesopolis, Nov 06 '14 at 13:34
possible duplicate of [Calculate difference between two dates (number of days)?](http://stackoverflow.com/questions/1607336/calculate-difference-between-two-dates-number-of-days) — Sam Hanley, Nov 06 '14 at 14:34

Paweł Reszka · Accepted Answer · 2015-10-12T09:30:07.047

3

Just parse both dates and then substract them and count total days like this:

DateTime date1 =   DateTime.ParseExact(dateString1, "d/M/yyyy", CultureInfo.InvariantCulture);
DateTime date2 =   DateTime.ParseExact(dateString2, "d/M/yyyy", CultureInfo.InvariantCulture);
var days = (int)(date2-date1).TotalDays;

edited Oct 12 '15 at 09:30

answered Nov 06 '14 at 13:31

Paweł Reszka

1,557
4
20
41

My date1 is (txtdate) and date2 is (txtdate1). How it convert to DateTime – Dwane Marsh Nov 06 '14 at 13:34
Just change dateString1 to txtdate and dateString2 to txtdate1 – Paweł Reszka Nov 06 '14 at 13:35
Also notice that i assumed that 11 is a month. If it is a day you should change pattern to: "MM/dd/yyyy" – Paweł Reszka Nov 06 '14 at 13:37
@Paweł Reszka, It works but it shows date with time like 12:00:00 Am, so I didint get the expected output. how to change this date format?? – Dwane Marsh Nov 06 '14 at 13:42
12:00:00 am is the beggining of the day. It's like you have 0 hours, minutes and seconds in you DateTime. In C# there is not type like Date, where you don't have hours, minutes etc – Paweł Reszka Nov 06 '14 at 13:46
Is it causing any problems? Calculated days should be correct. – Paweł Reszka Nov 06 '14 at 13:47
Yes it shows output as 1.0 – Dwane Marsh Nov 06 '14 at 13:55
Because its returning double. Check in a second my edited answer – Paweł Reszka Nov 06 '14 at 13:56

score 2 · Answer 2 · edited May 23 '17 at 12:06

2

I feel taking risk to answer this but..

You can use DateTime.ParseExact or DateTime.TryParseExact methods to parse your strings and subtract each other and use TimeSpan.TotalDays property. You can use TimeSpan.Days property as well if you are interested in the total days as an int rather than a double.

string txtdate = "8/11/2014";
DateTime dt;
if(DateTime.TryParseExact(txtdate, "d/MM/yyyy",
                          CultureInfo.InvariantCulture,
                          DateTimeStyles.None, out dt))
{

}
string txtdate1 = "9/11/2014";
DateTime dt1;
if(DateTime.TryParseExact(txtdate1, "d/MM/yyyy",
                          CultureInfo.InvariantCulture,
                          DateTimeStyles.None, out dt1))
{

}

var totaldays = (dt1 - dt).Days; // 1

You said;

I need output as 8/11/2014-9/11/2014=1. But I applied your code it shows output like 1.0?

I told you TotalDays property returns double and Days property returns int. But besides that, you seems like a result as 9/11/2014 - 8/11/2014 = 1 instead of just 1. In such a case, you can use string.Format like;

var result = string.Format("{0} - {1} = {2}",
                           dt1.ToString("d/MM/yyyy", CultureInfo.InvariantCulture),
                           dt.ToString("d/MM/yyyy", CultureInfo.InvariantCulture),
                           totaldays);

result will be 9/11/2014 - 8/11/2014 = 1

edited May 23 '17 at 12:06

Community

1
1

answered Nov 06 '14 at 13:35

Soner Gönül

97,193
102
206
364

Sorry 8 and 9 are days it is in the format of "dd/MM/yyyy" – Dwane Marsh Nov 06 '14 at 13:45
@DwaneMarsh What do you mean they are _dates_? You mean days? And what do you expect as a result of total days? – Soner Gönül Nov 06 '14 at 13:46
Pardon it is days. Typing mistake – Dwane Marsh Nov 06 '14 at 13:48
@DwaneMarsh You can use `d/MM/yyyy` format in such a case. Updated my answer. But really, what do you want as an output of total days? – Soner Gönül Nov 06 '14 at 13:50
I need output as 8/11/2014-9/11/2014=1. But I applied your code it shows output like 1.0? – Dwane Marsh Nov 06 '14 at 13:54
@DwaneMarsh Updated my question. Use `Days` if you want to return `int` as a result. – Soner Gönül Nov 06 '14 at 14:04
Thanks a lot Mr.Soner Gönül for spend your valuable time with my foolish question. I got answer. Even though I understood something .. – Dwane Marsh Nov 06 '14 at 14:07

How to find number of days from two string type dates?

2 Answers2