Rick,
        Can you explain your situation a little more in depth? There are
datepart() functions that allow us to compare parts of dates.

Greg


Sure, thanks for the interest. 

We have several thousand records in a db with a standard odbc datetime stamp column.  
We want to be able to filter out end of month statistics (all trouble calls in 
November, 2002, for instance) by using a set of drop down menus (month, year, type of 
call).   

This is the kind of product one sees everywhere on the internet, but I just can't find 
a reference piece to get my head in the right place about how to go about it.  Plus, 
as I've learned, there are always several approaches to the same problem.  

Any ideas are appreciated.  

Rick 

Reply via email to