Start and end date of month

[ccnorris]

I am trying to calculate the start and end dates for a month. I am using the
formulas:

<cfset first_of_month =
#CreateODBCDate(CreateDate(Year(Now()),Month(Now() ),1))#>
<cfset last_of_month =
#CreateODBCDate(CreateDate(Year(Now()),Month(Now() ),DaysInMonth(Now())))#>

When I try to insert the data into the database I get the following error
message:
"ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression ''{d '2005-07-01'}''."

Any help with this will be much appreciated!

[mxstu]

Can you post your insert query?

[ccnorris]

Sure. This is only part of it. I am just using this part for now to test the
new field names.

<cfquery name="newdata2" datasource="DBSales">
INSERT INTO moinprogress(month_num,
first_of_month,
last_of_month,
1)
VALUES('#month_num#',
'#first_of_month#',
'#last_of_month#',
'#DTOTAL#')
</cfquery>

[mxstu]

Just get rid of the single quotes around the date variables:

<cfquery name="newdata2" datasource="DBSales">
INSERT INTO moinprogress(month_num,
first_of_month,
last_of_month,
1)
VALUES('#month_num#',
'#first_of_month#',
'#last_of_month#',
'#DTOTAL#')
</cfquery>

[ccnorris]

Thanks! I should have tried that. I was making it harder than it really was. Thanks again!!