Nested Repeat By Date
I am trying to setup a nested repeat by dates.
The main category pulls the dates from the product table by month and year.
SELECT YEAR(DateAdd) AS 'year', MONTH(DateAdd) AS 'month'
GROUP BY year, month
ORDER BY year DESC, month DESC
So this will list the most recent 12 month entries as Month/Year
Now the nested repeat will pull the new products that were added within the relative Month/Year.
SELECT vdID, DateAdd, vidcateID, Title, Photo, Display
WHERE Display = 1 AND DateAdd = colname
GROUP BY DateAdd DESC
Is this correct?