Need to concatenate date and insert

[Chloeee]

I am passing a date from a form in 2 parts (month and year)

The following code is giving me an error. The error is related to the date. Any ideas?

<cfif isDefined(&quot;Form.addrecord&quot;)>
  <cfset theDate = CreateDate(Form.theYear, Form.theMonth, 1)>
  <cfquery name=&quot;insert_newsletter&quot; datasource=&quot;thedatesource&quot; dbtype=&quot;ODBC&quot;>
    INSERT INTO Newsletter(NewsletterDate, NewsletterTitle) 
	VALUES ('#theDate#','#Form.NewsletterTitle#')
  </cfquery>  
</cfif>

 

[Chloeee]

Okay, Okay...

I fixed my own problem at long last by removing the single quotes from #theDate#.

I thought I'd post the solution for future archive search for others.