What John says is correct...your syntax will work in SQL Server. If you are using some other database you will probably want to look at datepart().
-- jon mailto:[EMAIL PROTECTED] Wednesday, September 3, 2003, 4:56:31 PM, you wrote: BG> I know there is an easy answer to this that's escaping me at the moment. BG> CF has a function Month() which will pull the number of the month out of a BG> date. Is there a similar function to use in a SELECT statement that works BG> the same way? BG> Here's what I want: BG> SELECT My_Date BG> FROM All_Dates BG> WHERE Month(My_Date) = 8 BG> Returns all entires from All_Dates that are August. Easy? BG> Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
