INSERTing a date with Coldfusion

[Andrew K.]

Okay so I'm using ColdFusion and I'm trying to insert a date into a database.I got the Error Executing Database Query. error and I look at my query and it only makes sense that the date is being entered wrong because the only other values I am entering are numbers and I know how to enter them.So what is the correct way to insert a date (ex. #now()#) into a database?

[Nakor]

You should post your SQL statement. This could be because the cell that you are trying to insert a date into is not of the 'date' type. If you are not sure that you are using the date variable correctly for the insert read here.http://us3.php.net/date