How i convert date in yyyy/mm/dd

Question

How i can Change my date into yyyy-mm-dd format and this From and to are parameters of SQL Stored Procedure .so please tell me what i do

txt_from.Text='01/08/2015';

txt_to.Text='03/08/2015';

DateTime from = new DateTime(Convert.ToInt32(txt_from.Text.Split('/')[2]), Convert.ToInt32(txt_from.Text.Split('/')[1]), Convert.ToInt32(txt_from.Text.Split('/')[0]));

DateTime to = new DateTime(Convert.ToInt32(txt_to.Text.Split('/')[0]), Convert.ToInt32(txt_to.Text.Split('/')[1]), Convert.ToInt32(txt_to.Text.Split('/')[2]));

if (to > Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
RegisterClientScriptBlock("alert", "<script>alert('To date can not be later than current date.');</script>");
}
else
{
to = to.AddDays(1);
if (from <= to)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@from",from),
new SqlParameter("@to",to),
new SqlParameter("@PortalId",Convert.ToInt32( Session["PortalId"]))

};

Abhay Shanker · Answer

Try as below string dateString = 5/06/2015; string format = dd/mm/yyyy; DateTime dateTime = DateTime.ParseExact(dateString format CultureInfo.InvariantCulture); string strNewDate = dateTime.ToString(yyyy-dd-mm);

Rajeesh Menoth · Answer

Hi Write like this.. //Put thiz code using System.Globalization; DateTime From = DateTime .ParseExact(txtFrom.Text  yyyy/mm/dd   CultureInfo .InvariantCulture); Ref this : https://rajeeshmenoth.wordpress.com/2014/11/12/string-was-not-recognized-as-a-valid-datetime/

Upendra Pratap Shahi · Answer

string DateString = 11/12/2009 ; IFormatProvider culture = new CultureInfo( en-US  true ); DateTime dateVal = DateTime .ParseExact(DateString yyyy-MM-dd  culture);

Amitesh Verma · Answer

string DateString = 11/12/2009; IFormatProvider culture = new CultureInfo(en-US true); DateTime dateVal = DateTime.ParseExact(DateString yyyy-MM-dd culture); refer to this 1.http://stackoverflow.com/questions/12257483/c-sharp-how-to-convert-any-date-format-to-yyyy-mm-dd 2.http://stackoverflow.com/questions/19296433/convert-datetime-in-c-sharp-to-yyyy-mm-dd-format-and-store-it-to-mysql-datetime