Conversion from string "'5/01/2006'" to type 'Date' is not valid.

[FastEddie]

I am working on converting a VB 2003 to VB 2005 and I have run into this error Conversion from string "'5/01/2006'" to type 'Date' is not valid.

on this peice of code.

MonthStartDate = ("'" & _
        CStr(MonthCalendar1.SelectionStart.Month) & "/01/" & _
        CStr(MonthCalendar1.SelectionStart.Year) & "'")

I know it is a type conversion error but I am not sure how to fix it.

[gigemboy]

I presume MonthStartDate is a Date object, and you are trying to assign it a String. It doesn't work like that. Look into Date.Parse or Date.TryParse in order to parse a string date into a Date object.

Dim MyString As String = "01/01/2006"
        Dim MyDate As Date = Date.Parse(MyString)
        MessageBox.Show(MyDate.ToLongDateString)

[warrenayen]

Why are you enclosing it in a '? That's probably why you're having an issue. Try:

MonthStartDate = (CStr(MonthCalendar1.SelectionStart.Month) & "/01/" & CStr(MonthCalendar1.SelectionStart.Year))

[jmcilhinney]

Why bother turning your numbers into a string and then turning the string into a date? Just turn the numbers straight into a date:

Dim selectionStart As Date = Me.MonthCalendar1.SelectionStart
 
MonthStartDate = New Date(selectionStart.Year, selectionStart.Month, 1)

[FastEddie]

Some one else wrote the program. I am just doing the converting and in some cases am having a hard time telling what the original author was trying to achieve. Usually VS is able to provide some useful advice in how to fix these problems but in this case it just gives me the error. I tried your suggestion and so far it seems to be doing the trick.

Thanks!