Date Formatting

sdnaffi

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.Message,Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } This gives an error saying InvalidCastingException Solve this pls

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

djohncon21y ago
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.Text,System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat); string sNow = ""; sNow = ddt.ToString("dd/MMM/yyyy"); // forces date format to Day,Month, 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
shimtanny21y ago
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
shimtanny21y ago
Ah, then you have fist to check for null. If the the value is null, you can't format it.
sdnaffi21y ago
yeah it contains DataTime object. But it can be null if it not could i do for formatting date
shimtanny21y ago
Hi It seems to me, that c.Value contains not a DateTime object. So, what does it contain? Simon