Date Formatting

Question

Hey I tried this private void ReceiptDateFormat(object sender ConvertEventArgs c) { try { DateTime dt = (DateTime)c.Value; c.Value = dt.ToString(dd/MM/yyyy); } catch(Exception ex) { MessageBox.Show(Error #:  +   + ex.MessageApplication.ProductName MessageBoxButtons.OK MessageBoxIcon.Error); } } This gives an error saying InvalidCastingException Solve this pls

djohncon · Answer

Hi all you need to do is parse the date using globalisation otherwise it will not except dd/MM/yyyy. Also I would have thought that date would be a not null field in a receipt. you can use this to force a not null input if(t_ID.Text !=&& t_Date.Text !=) this example demostrates how to insert a date using a text box into MS Access DB. if you do not use the globalization your string format will not be accepted. System.DateTime ddt = DateTime.Parse(t_Date.TextSystem.Globalization.CultureInfo.CreateSpecificCulture(en-AU).DateTimeFormat); string sNow = ; sNow = ddt.ToString(dd/MMM/yyyy); // forces date format to DayMonth Year t_Date.Text = '#'+sNow+'#'; strInsert += CDate(+t_Date.Text+')'+); there is a demo sample on C# Corner forum home page. hope this helps kamean

shimtanny · Answer

Hi Maybe i misunderstood you... If c.Value is a string containing a date/time stamp you could try to parse it: DateTime dt = DateTime.Parse(c.Value); c.Value = dt.ToString(.. your format ..); Simon

shimtanny · Answer

Ah then you have fist to check for null. If the the value is null you can't format it.

sdnaffi · Answer

yeah it contains DataTime object. But it can be null if it not could i do for formatting date

shimtanny · Answer

Hi It seems to me that c.Value contains not a DateTime object. So what does it contain? Simon