MySql date issue

[Guest]

hi i am inserting intp MySql date field, but when i insert the date 29/02/2009

i get the error MONTH

<cfset newdate = #DateFormat(CreateDate(form.vyear, form.vmonth, form.vday), "mm-dd-yyyy")#>

any ideas how to solve ths issue?

[gottagetcodin]

Craig

I believe in mysql dates must be cast yyyy-mm-dd, so just change dateformat in your code.

Buy Ben Forta's excellent book on mysql it makes it all seem easy.

Can someone now answer my cflayout question below craig's!!

Tim

[rollerskatie]

The date isn't valid because 2009 isn't a leap year, 2008 is. There is no 29th February in 2009 🙂

[-__cfSearching__-]

craiglaw98 wrote:
> hi i am inserting intp MySql date field, but when i insert the date 29/02/2009
> <cfset newdate = #DateFormat(CreateDate(form.vyear, form.vmonth, form.vday), "mm-dd-yyyy")#>

If you need to insert a date, do not use DateFormat. That function returns a string not a date time object. Also, you do not need the # signs.

<cfset newdate = CreateDate(form.vyear, form.vmonth, form.vday)>