Problem with date type

nelly78 · December 7th, 2009, 01:14 PM

Hi All,

I want convert the string type to date type but i am getting error.

Dim sDate as String = "12/15/2008"

Dim dAttrDate AsDate = "#" & sDate & "#"

the below error :

System.InvalidCastException: Conversion from string "#12/15/2008#" to type 'Date' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions .ToDate(String Value)

I am doing this because i want to fomat the date in below format after converting to date Type:

Dim dDate As New java.util.Date(CInt(Format(dAttrDate, "yyyy")) - 1900, _
CInt(Format(dAttrDate, "MM")) - 1, _
CInt(Format(dAttrDate, "dd")), _
CInt(Format(dAttrDate, "hh")), _
CInt(Format(dAttrDate, "mm")), _
CInt(Format(dAttrDate, "ss")))

How to avoid the above error.

Thanks
Nelly

gbianchi · December 7th, 2009, 01:30 PM

This is very confusing..

You are converting something to a Java date????????!?!??!!?!????

Are you using asp.net????

why don't create a datetime object with the date you need?? (use it as a parameter in the constructor)...

nqsousa · December 7th, 2009, 04:05 PM

nelly78
I would just use the CType(datetimeString,Date) function

Code:

Dim sDate as String = "12/15/2008" 

Dim dAttrDate As Date = CType(sDate, Date)

If you want to avoid having errors on run time depending on non-convertibility of sDate into a date, you may prefer to do encapsulate this in a Try ... Catch ... End Try routine like this

Code:

Dim sDate as String = "12/15/2008" 

Try
    Dim dAttrDate As Date = CType(sDate, Date)
Catch

End Try

gbianchi · December 9th, 2009, 10:54 AM

With that in mind, the OP can just use Cdate...