Dato, asp og mysql

CDate(myDate)

det skulle meget gerne løse dit problem.

myDate = Request.Form("year") & "-" & Request.Form("month") & "-" & Request.Form("day")
SQL = "INSERT INTO Calendar (Title, Description, Dato)"
SQL = SQL & " VALUES ("
SQL = SQL & "'" & clean(Request.Form("Title")) & "', "
SQL = SQL & "'" & clean(Request.Form("Description")) & "',"
SQL = SQL & "'" & Cdate(myDate) & "' "
SQL = SQL & ")"

Type mismatch: 'Cdate'

blot...

myDate = Request.Form("year") & "-" & Request.Form("month") & "-" & Request.Form("day")
myDate = CDate(myDate)
SQL = "INSERT INTO Calendar (Title, Description, Dato)"
SQL = SQL & " VALUES ("
SQL = SQL & "'" & clean(Request.Form("Title")) & "', "
SQL = SQL & "'" & clean(Request.Form("Description")) & "',"
SQL = SQL & "'" & myDate & "' "
SQL = SQL & ")"

Ja nu laver den ikke fejl, men datoen bliver forkert. 1. April 2004 blev til 2001-04-20

Jeg fandt denne funktion istedet som løser det for mig:
Function FormatDato( pstrDate )
        dim strDate
    dim strDay
    dim strMonth
    dim strYear
    dim strConvertedDate
       
    strDate        = FormatDateTime( pstrDate, vbShortDate )   
    strDay        = day( strDate )
    if len( strDay ) = 1 then
        strDay = "0" & strDay
    end if       
    strMonth    = month( strDate )
    if len( strMonth ) = 1 then
        strMonth = "0" & strMonth
    end if               
    strYear        = year( strDate )   
       
    strConvertedDate = strYear & "-" & strMonth & "-" & strDay
       
    FormatDato = strConvertedDate
End Function