Nested Repeat By Date
Hi Jason,
I am trying to setup a nested repeat by dates.
Example:
The main category pulls the dates from the product table by month and year.
SELECT YEAR(DateAdd) AS 'year', MONTH(DateAdd) AS 'month'
FROM VideoDictionary
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
FROM VideoDictionary
WHERE Display = 1 AND DateAdd = colname
GROUP BY DateAdd DESC
Is this correct?
thx
Eric