...

View Full Version : generating report problem



DigitalDre
06-22-2006, 10: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:

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

~Phil~

vinyl-junkie
06-22-2006, 02: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'



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum