Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filtering Date/Time attributes
- Thread starter GriLLo
- Start date
Hi GriLLo
I'm not positive about Access (if that's the DB you are using), but for SQL Server the following works...
<cfquery name="get_records" datasource="comweb" dbtype="ODBC">
SELECT *
FROM MyTable
WHERE Month(Date) = #userDefinedMonth#
</cfquery>
I'm not positive about Access (if that's the DB you are using), but for SQL Server the following works...
<cfquery name="get_records" datasource="comweb" dbtype="ODBC">
SELECT *
FROM MyTable
WHERE Month(Date) = #userDefinedMonth#
</cfquery>
- Status
Similar threads
- Locked
- Question