Problem converting string to datetime format

Question

Hi,

I am using calender extender for 2 textboxes allowing user to enter start and end date.. The format is "dd/MM/yyyy".. My code is as below for converting to datetime..

private int duration(string startdate, string enddate)
    {

        DateTime dt1= DateTime.Parse(startdate);
        DateTime dt2= DateTime.Parse(enddate);
        //dt1 = Convert.ToDateTime(txtstartdate.Text);
        //dt2 = Convert.ToDateTime(txtenddate.Text);
        TimeSpan ts = dt2.Subtract(dt1);
        int days = ts.Days;
        Session["days"] = days.ToString();
        return days;
    }
    protected void txtenddate_TextChanged(object sender, EventArgs e)
    {
       int projectdays = duration(txtstartdate.Text, txtenddate.Text);

        txtduration.Text = Convert.ToString(projectdays);
    }
==================
When user selects the date from calender extender say todays date.9/1/2012
it is been taken as 1 september 2012

Manoj Savalia · Answer

Please try this, var dt = new DateTime(2010, 06, 26); // time is zero by default string currTime = "19:04:06";//dateTimePicker1.Value.TimeOfDay.ToString(); var tm = TimeSpan.Parse(currTime); var fullDt = dt + tm;

Anuja Pawar · Answer

Hey Suchitra, Try this DateTime dt1=DateTime.ParseExact(startdate, "yyyyMMdd", new DateTimeFormatInfo());

B M Suchitra · Answer

@Suthish, I tried your solution. But still getting this error: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: String was not recognized as a valid DateTime. Source Error: Line 176: Line 177: DateTime dt1= DateTime.Parse(Convert.ToDateTime(startdate).ToString("dd/MM/yyyy")); Line 178: DateTime dt2 = DateTime.Parse(Convert.ToDateTime(enddate).ToString("dd/MM/yyyy")); Line 179: //dt1 = Convert.ToDateTime(txtstartdate.Text); Line 180: //dt2 = Convert.ToDateTime(txtenddate.Text);

Mayur Gujrathi · Answer

Try this Pass your date in string to sql server and try the following CONVERT(VARCHAR,CONVERT(DATETIME,stringdate,103),106)+'23:59:59'

Satyapriya Nayak · Answer

You also can do it like... private int duration(string startdate, string enddate) { DateTime dt1 = Convert.ToDateTime(Convert.ToDateTime(txtstartdate.Text).ToString("dd/MM/yyyy")); DateTime dt2 = Convert.ToDateTime(Convert.ToDateTime(txtenddate.Text).ToString("dd/MM/yyyy")); TimeSpan ts = dt2.Subtract(dt1); Response.Write(ts.Days); int days = ts.Days; Session["days"] = days.ToString(); return days; } protected void txtenddate_TextChanged(object sender, EventArgs e) { int projectdays = duration(txtstartdate.Text, txtenddate.Text); TextBox1.Text = Convert.ToString(projectdays); } Thanks

Satyapriya Nayak · Answer

Hi Suchitra, @Suthish is correct. private int duration(string startdate, string enddate) { DateTime dt1 = DateTime.Parse(Convert.ToDateTime(txtstartdate.Text).ToString("dd/MM/yyyy")); DateTime dt2 = DateTime.Parse(Convert.ToDateTime(txtenddate.Text).ToString("dd/MM/yyyy")); TimeSpan ts = dt2.Subtract(dt1); Response.Write(ts.Days); int days = ts.Days; Session["days"] = days; return days; } protected void txtenddate_TextChanged(object sender, EventArgs e) { int projectdays = duration(txtstartdate.Text, txtenddate.Text); TextBox1.Text = Convert.ToString(projectdays); } Thanks

Suthish Nair · Answer

try.. DateTime dt2 = DateTime.Parse(Convert.ToDateTime(TextBox2.Text).ToString("dd/MM/yyyy"));

Aarti · Answer

Hi, try this private int duration(string startdate, string enddate) { DateTime dt1 = DateTime.Parse(startdate); DateTime dt2 = DateTime.Parse(enddate); dt1 = DateTime.Parse(textBox1.Text); MessageBox.Show("" + dt1.ToString("U")); dt2 = DateTime.Parse(textBox2.Text); MessageBox.Show("" + dt2.ToString("U")); TimeSpan ts = dt2.Subtract(dt1); int days = ts.Days; //Session["days"] = days.ToString(); return days; } protected void textBox2_TextChanged(object sender, EventArgs e) { int projectdays = duration(textBox1.Text, textBox2.Text); textBox3.Text = Convert.ToString(projectdays); }

Jignesh Trivedi · Answer

Hi, your date control is "calender" build in asp .net control. right? calender control has one property called "SelectedDate" to retrieve text in calender control in datetime format. please try this property and pass your argument "duration" function must be datetime format insted of string. private int duration(DateTime startdate, DateTime enddate) { .... .... } hope this help.

B M Suchitra · Answer

@Arati, I hope i am in asp.net forum only.. Yes i am.. I am working on VS2008

Aarti · Answer

Hi, I have given code in Silverlight. You didnt mention ASP.Net in your thread For ASP.NET( DATE PICKER) refer below links: http://www.dotnetfunda.com/articles/article746-how-to-create-a-date-picker-in-aspnet.aspx http://www.codeproject.com/KB/webforms/datepicker.aspx

B M Suchitra · Answer

Arati, I dont understand where is DatePicker in asp.net?

Aarti · Answer

Hi, Use datepicker instead of text boxes Try with below code: private int duration( ) { DateTime dt1; DateTime dt2 ; dt1 = Convert.ToDateTime(datePicker1.Text); MessageBox .Show( "" + dt1.ToString( "U" )); dt2 = Convert.ToDateTime(datePicker2.Text); MessageBox .Show( "" + dt2.ToString( "U" )); TimeSpan ts = dt2.Subtract(dt1); int days = ts.Days; //Session["days"] = days.ToString(); return days; } private void button1_Click(object sender, RoutedEventArgs e) { Int32 dd = duration(); MessageBox.Show("" + dd); }

B M Suchitra · Answer

@Jignesh, Ofcourse Calender extender is available only in asp.net ajax as i know.. But what is the solution?

Jignesh Trivedi · Answer

Hi, date format is depend on Current culture, so you have two way to find out duretion. 1) calculate culture free. i.e. "duration" function take arrgument as date insted of string. 2) you forcely convert to dd/mm/yyyy format. are you using asp.net? hope this help

Problem converting string to datetime format

Answers (15)