Hi, I am trying to do a very simple select query based on date.
Basically, the Date column has dates in the format: MM/DD/YYYY. I need to search for one month at a time. The simplest way I figured to do it, (but have no clue how) is to make the criteria (for this example January 2007): 1/(some sort of function or place holder that can be any value)/2007. I do not know if this exists, or if I have to search by date range or what.
Please help.
Basically, the Date column has dates in the format: MM/DD/YYYY. I need to search for one month at a time. The simplest way I figured to do it, (but have no clue how) is to make the criteria (for this example January 2007): 1/(some sort of function or place holder that can be any value)/2007. I do not know if this exists, or if I have to search by date range or what.
Please help.
Comment