newbie help

I just barely know enough CF to be dangerous... look out!!!

Here's my problem... I'm trying to group events by their date, but keep getting an undefined function in my query...

What am I doing wrong?? This site is using an Access DB and its throwing me for a loop.

here's my query...
select *, Dateformat(event_date, "mm/yy") as monthyear
from event_calendar
where rec_status = 'K'
order by monthyear

Then the output...
<cfoutput group="monthyear" query="getevents">

Any help would be appreciated
Thanks

The problem is with the Dateformat() within the Query. Dateformat is Coldfusion and the query commands are actually not Coldfusion.

Thanks... how do I fix it?

You either need to apply the CFML function when you later output the query data (after the query has run), or you need to use a native database function to format the date in the query itself (check the documentation for your database).

You can use access native function to format date. The f unction is called Format and here is a reference.

http://www.techonthenet.com/access/functions/date/format.htm