Syntax Error in SQL for updating Date field

[safeerbinsalih]

Hello,

I'm struggling with a syntax error in SQL for updating date in a field

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim GRN_date As Date
Dim temp_date As Variant

Set db = CurrentDb()
Set rs = db.OpenRecordset("PostedGRNfinal")
With rs

GRN_date = rs!GRN_date
temp_date = DMin("GRN_date", "PostedGRNfinal")
'to find the earliest date in field GRN_date

End With
strSQL = "UPDATE [Support_data2] SET [Start_date] = #" & Format(temp_date, dd - mm - yyyy) & "#"

db.Execute strSQL, dbFailOnError


This statement is showing "syntax error in date in qyery expression '#42367'

 

[cyanidem]

Date for SQL string should be provided in format MM/DD/YYYY

 

[arnelgp]

Format(temp_date, "dd - mm - yyyy")

 

[safeerbinsalih]

Thank you. It worked

strSQL = "UPDATE [Support_data2] SET [Start_date] = #" & Format(temp_date, "dd - mm - yyyy") & "#"
db.Execute strSQL, dbFailOnError