Convert Date to appropriate format

[RP]

I am using SQL Server 2005 as backend. I have a Text Box that accepts
Date in the format dd-MM-yyyy. But when I attempt to insert a record,
an error is displayed: Cannot convert char to DateTime ....

Actually, when the text box has entry like 22-10-2005, it considers 22
as month whereas it is DD. How to convert the Text Box value to an
acceptable format.

I tried: DateTime.parse(txtDOB.Text,"dd-MM-yyyy")

It gives error.

[Tom Porterfield]

RP wrote:

I am using SQL Server 2005 as backend. I have a Text Box that accepts
Date in the format dd-MM-yyyy. But when I attempt to insert a record,
an error is displayed: Cannot convert char to DateTime ....

Actually, when the text box has entry like 22-10-2005, it considers 22
as month whereas it is DD. How to convert the Text Box value to an
acceptable format.

I tried: DateTime.parse(txtDOB.Text,"dd-MM-yyyy")

It gives error.

There is no overload of DateTime.Parse that takes a date and a format.
Use ParseExact instead. Ex:

DateTime dt = DateTime.ParseExact(txtDOB.text, "dd-MM-yyyy",
System.Globalization.DateTimeFormatInfo.CurrentInf o);
--
Tom Porterfield

[RP]

Tried as below. But still errors.

On Aug 16, 11:28 pm, Tom Porterfield <[e-mail]:

There is no overload of DateTime.Parse that takes a date and a format.
Use ParseExact instead. Ex:

DateTime dt = DateTime.ParseExact(txtDOB.text, "dd-MM-yyyy",
System.Globalization.DateTimeFormatInfo.CurrentInf o);

[joachim]

what's wrong with?

string inputSplit = txtDOB.Text.Split(new char[] { '-' });
// dd-MM-yyyy to yyyy-MM-dd
DateTime newDate = new DateTime(
Convert.ToInt16(inputSplit[2]),
Convert.ToInt16(inputSplit[1]),
Convert.ToInt16(inputSplit[0]));

Regards,
Joachim

[Rad [Visual C# MVP]]

On Thu, 16 Aug 2007 17:40:24 -0000, RP <rp*********@gmail.comwrote:

>I am using SQL Server 2005 as backend. I have a Text Box that accepts
Date in the format dd-MM-yyyy. But when I attempt to insert a record,
an error is displayed: Cannot convert char to DateTime ....

Actually, when the text box has entry like 22-10-2005, it considers 22
as month whereas it is DD. How to convert the Text Box value to an
acceptable format.

I tried: DateTime.parse(txtDOB.Text,"dd-MM-yyyy")

It gives error.

Hi RP,

You could eliminate 99% of your headaches by using more appropriate
controls like a datepicker or a calendar. The reason being you do not
need to write any validation code and your date serialization will be
independent of gotchas like client pc's regional settings

--
http://bytes.thinkersroom.com