Hey all,
I have some entries in a mysql database that have a column of 'week ending' where the date looks like 4/13/2004. What I would like to do is have the end user select from a form a month they would like to view data for. Is there any way to pull just the rows with a week ending date that is in a particular month? ie.. (where the weekending date is between Jan 1 and Jan 31 ) Thanks all!
choose a day as weekend.. consider saturday as the weekend and month should be january
use this type of query to get the values
select * from ex_tablename where dayname(weekendingdate) = 'Saturday' and month(weekendingdate) = 1
