Syntax error into Insert Statement

[starclassic]

DoCmd.RunSQL "INSERT INTO tblDraftEntry (FormIDEntry,COCodeEntry,BeginEntry,EndingEntry,Date) Values" _
& "('" & Me.cboFormNumber & "', '" & Me.txtCode & "', " _
& "'" & Beginning & "', '" & Ending & "', '" & Format(Now(), "mm/dd/yyyy") & "')"

Not sure where the syntax error as it worked fine on my other programs, seems to be pointing on the Format(now(), "mm/dd/yyyy").

Thanks for the help.

 

[Remou]

The delimiter for dates is hash (#) not apostrophe (').

 

[jadams0173]

Dates should be incapsulated in # not ' in JET sql.

#" & Format(Now(), 'mm/dd/yyyy') & "#,'" &

 

[starclassic]

DoCmd.RunSQL "INSERT INTO tblDraftEntry (FormIDEntry,COCodeEntry,BeginEntry,EndingEntry,Date) Values" _
& "('" & Me.cboFormNumber & "', '" & Me.txtCode & "', " _
& "'" & Beginning & "', '" & Ending & "', #" & Format(Now(), "mm/dd/yyyy") & "#)"
Its still get me the same error.

 

[Remou]

Numbers do not require delimiters. Date is a reserved word and should not be used as a field name, if it is used, it ought to be bracketed: [Date]

 

[starclassic]

Thanks Remou,

I change the date field on table to DateToday and works fine now.

Thanks
Again