View Full Version : generating report problem

06-22-2006, 09:20 AM
can you help me? how do you generate a date range report script base on a specific. For example, if i want to display a report in the month of june from 2004 to 2005 or in the month of july from 2002 to 2003? Thanx :confused:

06-22-2006, 10:03 AM
This isn't a very helpfull question. What are you generating from where?


06-22-2006, 01:13 PM
Are you trying to figure out how to write the query to retrieve this kind of data from your database? If so, here's one way of doing that.

Select * from tablename
where mydate between '2004-06-01' and '2005-06-30'