Hi All,

Im in the process of building a call loggin system and its finally been put on the server, but i keep getting the above error "Title" the first stage it goes to be authorised and when the authoriser auths it...it updates the table with the date they authorised it. which is fine, the next stage is the Business Analyst where they check all the content of the task and then approve it but for some reason unknown to me it keeps falling over on the .dateAuthorised

My Sql Column to hold the date authorised is a Datetime datatype and im converting a string to a data time within the procedure this is my Code behind page

Code:
  Dim StatusNew As Integer = 53
                    Dim CurrentStage As Integer = 51
                    ITUpdateTaskTable.Add("@spWorkID", Replace(TskNumLab.Text, "LC", ""))
                    ITUpdateTaskTable.Add("@spTitle", txtTitleContent.Text)
                    ITUpdateTaskTable.Add("@spDescription", txtDescription.Text)
                    ITUpdateTaskTable.Add("@spJustification", txtJustification.Text)
                    ITUpdateTaskTable.Add("@spRequiredBy", txtDateRequired.Text)
                    ITUpdateTaskTable.Add("@spCurrentStage", CurrentStage)
                    ITUpdateTaskTable.Add("@spDateAuthorised", Format(.DateAuthorised, "dd/MM/yyyy"))
                    ITUpdateTaskTable.Add("@spTeamName", "BA Approval")
                    ITUpdateTaskTable.Add("@spComment", txtITValComments.Text)
                    ITUpdateTaskTable.Add("@spITLevelEstimate", txtITValLevelEstimate.Text)
                    ITUpdateTaskTable.Add("@spCategoryID", cmbCategory.SelectedValue)
                    ITUpdateTaskTable.Add("@spBusinessAreaID", cmbBusinessArea.SelectedValue)
                    ITUpdateTaskTable.Add("@spPriorityID", cmbPriority.SelectedValue)
                    ITUpdateTaskTable.Add("@spTeamID", cmbBAAllocatedTeam.SelectedValue)
                    ITUpdateTaskTable.Add("@spAssignUserID", BAAssingToAUser.Value)
                    ITUpdateTaskTable.Add("@spDeptPriority", .DeptPriority)
                    ITUpdateTaskTable.Add("@spRaisedFor", .RaisedFor)
                    ITUpdateTaskTable.Add("@spUserID", UserID)
                    ITUpdateTaskTable.Add("@spOldTeam", OldTeamID)
                    ITUpdateTaskTable.Add("@spUserRef", .UserReference)
                    ITUpdateTaskTable.Add("@spAssignUserType", "User")
                    ChangeClass.UpdateRecord(ITUpdateTaskTable, StatusNew)
                    EmailSend.SendAssignmentUser("TaskTracker", Replace(TskNumLab.Text, "LC", ""), txtTitleContent.Text, BAAssingToAUser.Value, )
                    EmailSend.Send()
                    Response.Redirect("MyWorkRequest.aspx?Update=" & message)
The field in error is ITUpdateTaskTable.Add("@spDateAuthorised", Format(.DateAuthorised, "dd/MM/yyyy"))

the formats i have tried are as follows .DateAuthorised, DateAuthorised.tostring and one you can see above here is my proc

Code:
UPDATE wrp_Work
   SET chrWorkDesc = @spDescription
        , chrWorkTitle = @spTitle
        , intStatus = @spStatusID
        , intAssignTo = @spAssignUserID
        , chrAssignToType = @spAssignUserType
        , intModBy = @spUserID
        , datModified = @CurrentDate
        , chrJustification = @spJustification
        , chrUserRef = @spUserRef
        , chrEstimateHigh = @spEstimateHigh
        , chrEstimateLow = @spEstimateLow
        , datAuthorised = convert(datetime,@spDateAuthorised, 103)
        , chrActualWork = @spActualWork
        , intCategoryID = @spCategoryID
        , intPriority = @spPriorityID
        , datRequired = convert(datetime,@spRequiredBy, 103)
	    , intRaisedFor = @spRaisedFor
        , intBusinessArea = @spBusinessAreaID
        , intSignedOffByID = @spintSignedOffByID
       , intDeptPriority = @spDeptPriority
        , intITValLvEst = @spITLevelEstimate
        , intDevelopmentLvEst = @spDevelopmentLevelEstimate
		, intDeveloperLvEst = @spDeveloperLevelEstimate
        , chrAldonTaskNum = @spAldonTaskNumber
        , intBALvEst = @spBATestEstimate
        , intBAUserTestEst = @spBAUserTestEstimate
        , intReleaseNum = @spReleaseNumber
		, intTeamID = @spTeamID
WHERE intWorkID = @spWorkID
Im banging my head at this so please any advice would be highly appreciated im not doing anything with the field it self just passing it back in to SQL and yes this is very irriatating but i didnt design the date base nor do i have time tto re-design it so if i field is missing it wont load the Task