My date is being saved as a Time 1

[ckeener]

I probably have a dumb mistake that I just can't see, but whenever I try to update a date field in my table, it changes it to a time. For example, this code

'If there is an ApprovedDate in txtApprDate1, then insert 
'it into the ApprovedDate field in tblLogs
        If Not IsNull(Me.txtApprDate1) Then
            If IsDate(Me.txtApprDate1) Then
                strSQL = "UPDATE tblLogs SET ApprovedDate = " & Me.txtApprDate1 & _
                    " WHERE LogRef = " & TempRef
            Else
                MsgBox "Please enter a Valid Approved date 1", vbExclamation
            End If
            db.Execute strSQL
        End If

This changes 9/30/1992 to 12:00:13 AM

What am I doing wrong?????

Thanks CalebK

 

[tinymind]

Try this strsql

strsql = "UPDATE tblLogs SET ApprovedDate = #" & Me.txtApprDate1 & "# WHERE LogRef = " & TempRef

Tiny

Perfection is Everything
If it worked first time we wont be here!

 

[ckeener]

Thanks Tiny,

That is exactly what I needed! Thank you for your response!

Caleb