Yep you are... >> WHERE DatePart(yyyy,EventDate) = ???? AND DatePart(yyyy,EventDate)= ????
This will not work... the first part of the Where clause needs to be something like WHERE EventDate >= '[YOURDATE]' I am not sure what format your date is in, but I think you get the idea :-p -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 14:38 To: CF-Talk Subject: Simple Query Help I need to parse a query to a calendar database that returns just the current month's events, and I'm hung up on the Where part of the query (I'm obiously also getting very confused between CF and SQL functions). <cfquery name="Q_Month" datasource="command_calendar"> SELECT Title, Details, EventDate, StartHour, StartMin FROM Events WHERE DatePart(yyyy,EventDate) = ???? AND DatePart(yyyy,EventDate)= ???? ORDER BY EventDate ASC </cfquery> Am I on the right track here? Is there a better way? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
