Date format question

Question

I have aporject that is en_GB globalized but the data base the project is reading is in US format how can I convert the strings I have to US format but still read UK format on the GUI.

Amy Turnbull · Answer

would this work with strings I have at the moment string strSdate = (string) cdrCalendarStart.SelectedDate.ToShortDateString(); strSdate = String.Format({0:MM/dd/yyyy 00:00.00}strSdate); string strFdate = (string) cdrCalendarFin.SelectedDate.ToShortDateString(); strFdate = String.Format({0:MM/dd/yyyy 00:00.00}strFdate);

Scott Lysle · Answer

If you are doing this on a a case by case basis you can use any of these: public Form1() { InitializeComponent(); textBox1.Text = DateTime .Now.ToShortDateString(); } private void button1_Click( object sender EventArgs e) { // using UI culture CultureInfo ciEnglishGB = new CultureInfo ( en-GB ); DateTime dtGreatBritian = Convert .ToDateTime(textBox1.Text); textBox2.Text = dtGreatBritian.ToString(ciEnglishGB.DateTimeFormat.ShortDatePattern); } private void button2_Click( object sender EventArgs e) { // e.g. 23/10/2007 string [] usDate = textBox1.Text.Split( '/' ); textBox2.Text = usDate[1] + / + usDate[0] + / + usDate[2]; } private void button3_Click( object sender EventArgs e) { // e.g. 23/10/2007 string [] usDate = textBox1.Text.Split( '/' ); DateTime dtGreatBritain = new DateTime ( Convert .ToInt32(usDate[2]) Convert .ToInt32(usDate[0]) Convert .ToInt32(usDate[1])); textBox2.Text = dtGreatBritain.ToString( dd/MM/yyyy ); } private void button4_Click( object sender EventArgs e) { // text abbreviated month (e.g. Oct) string [] usDate = textBox1.Text.Split( '/' ); DateTime dtGreatBritain = new DateTime ( Convert .ToInt32(usDate[2]) Convert .ToInt32(usDate[0]) Convert .ToInt32(usDate[1])); textBox2.Text = dtGreatBritain.ToString( dd MMM yyyy ); } private void button5_Click( object sender EventArgs e) { // text month spelled out (e.g. October) string [] usDate = textBox1.Text.Split( '/' ); DateTime dtGreatBritain = new DateTime ( Convert .ToInt32(usDate[2]) Convert .ToInt32(usDate[0]) Convert .ToInt32(usDate[1])); textBox2.Text = dtGreatBritain.ToString( dd MMMM yyyy ); }