convert string to date

Elliot · Joined: 12 Dec 2007 Posts: 5

How can to save a string("13/12/2007") in a field which datatype is date in
the table?

field["dob"] = xxx?

Archived from group: microsoft>public>dotnet>framework>aspnet

Mark Rae [MVP] · Joined: 08 Aug 2007 Posts: 29

"Elliot" wrote in message @microsoft.com...

> How can to save a string("13/12/2007") in a field which datatype is date
> in the table?
>
> field["dob"] = xxx?

field["dob"] = Convert.ToDateTime("13/12/2007");
field["dob"] = DateTime.Parse("13/12/2007");
field["dob"] = ParseExact("13/12/2007", "dd/MM/yyyy", null);

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Mark Rae [MVP] · Joined: 08 Aug 2007 Posts: 29

"Mark Rae [MVP]" wrote in message @TK2MSFTNGP02.phx.gbl...

> field["dob"] = ParseExact("13/12/2007", "dd/MM/yyyy", null);

Apologies - slip of the Enter key...

field["dob"] = DateTime.ParseExact("13/12/2007", "dd/MM/yyyy", null);

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Elliot · Joined: 12 Dec 2007 Posts: 5

Useful!
Thanks again.

"Mark Rae [MVP]" wrote in message #KnLYPIHA.536@TK2MSFTNGP06.phx.gbl...
> "Mark Rae [MVP]" wrote in message
> @TK2MSFTNGP02.phx.gbl...
>
>> field["dob"] = ParseExact("13/12/2007", "dd/MM/yyyy", null);
>
> Apologies - slip of the Enter key...
>
> field["dob"] = DateTime.ParseExact("13/12/2007", "dd/MM/yyyy", null);
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net

Time convert Hello, I have a database that I have been querying from my visual basic program to take my access DB and convert it to excel. I use a multitude of SQL queries to get it to the format I desire, but i have a time column that has both the date and time withi

how to convert VB6 project without VB6 We have VB.NET 2002 but need to work on some code a client developed in VB6. We've been unable to upgrade their VB6 project due to some missing components (DAO350.DLL & and the Upgrade Wizard recommends that we install VB6 first before upg

convert HTML to Word doc I have this code that creates an HTML formatted document and I can open the document through Word. But I want the format to be truely MS Word (2003). Does anyone know how to do this? Here's my code that does the first conversion: xmlfile = "myfile.xml" x

Convert.ToDateTime using MM/yy format Suppose a user wants to allow entry of credit card expiration dates in the two digit year format of MM/yy. Conversion of the textual date (like 03/06) to a DateTime structure behaves unexpectedly when using Is this a bug in the ToDateT

How convert a base class into a subclass?? I have a class which inherits from The code is basically (property procs omitted for clarity): Public Class DataTable() Inherits Public Property SQL As String = "" End Class Now, i have a proc which given a SQL