My guess is a format descrepancy. You should use the cfqueryparam tag or the createODBCDate() function to pass in your date into the query.
<cfquery name="January" datasource="dsn">
DatePart('m', [StartDate]) = <cfqueryparam value="1" cfsqltype="CF_SQL_INTEGER" />
and StartDate >= <cfqueryparam value="#Today#" cfsqltype="CF_SQL_DATE" />
and Archive = <cfqueryparam value="0" cfsqltype="CF_SQL_INTEGER" />
ORDER BY StartDate ASC, StartTime ASC
Hope this helps.
Can you please confirm the data type of the StartDate column. When you say it's "formatted as mm/dd/yyyy", is that just what you're seeing on the screen in front of you, or have you really got a varchar (etc) column in which you are storing date data as poorly-formatted strings?
Thank you, Steve and Adam. Steve's suggestion solved the issue I was having.