Updating dates in a table with an update query 2

[Guest_imported]

I have a table in my database with a date field--the dates are formatted like this: 20000908. I want to somehow--probably using an update query--change the date to be formatted like this: 9/8/00. How do I do this?

 

[Phooey]

Have you tried using the format or CDate function in the value to be updated? [sig][/sig]

 

[Smashie]

You could do it in code like this:

Private Sub Command4_Click()
Dim yy As String
Dim dd As String
Dim mm As String
yy = Mid(dt, 3, 2)
mm = Mid(dt, 5, 2)
dd = Mid(dt, 7, 2)
dateform = mm & "/" & dd & "/" & yy
End Sub

Apply the above conversion to the recordset behind a form (for example) [sig][/sig]