CCConf.startDate = "04/01/2009";
CCConf.endDate = "04/31/2009";
Technically '04/01/2009' and '04/31/2009' are not dates, they are strings that humans can read as dates. ColdFusion will do it's best to try and convert strings like these into dates. Sometimes it has trouble - like when some string tries to tell it the forth month, April, has 31 days.
You may want to investigate something like createData() that more explicity tells CF how to create a date out of values.
I am trying to odbcdate doesnt work... same error. pls guide me.
APRIL DOES NOT HAVE 31 DAYS!
4/31/2009 (or any year) is an illegal date and can NOT be converted into a date variable by any code!
Thank u vm