Converting string to Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Scarlett - 09 Apr 2005 16:43 GMT

Hello! I have inherited a DB containing dates as nvarchar 50!! Is there a
function to convert this to a genuine datetime datatype?

Reply to this Message

John Nurick - 09 Apr 2005 18:25 GMT

Hi Jim,

There are zillions of ways of representing dates as text. The built-in
CDate() function will convert some of them; otherwise the usual
technique is to parse the string into numbers representing year, month
and day (using VBA functions such as Left(), Mid(), InStr()) and then
pass these to the DateSerial() function which combines them into returns
a date value.

>Hello! I have inherited a DB containing dates as nvarchar 50!! Is there a
>function to convert this to a genuine datetime datatype?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message