I am creating a report that displays whether or not the user submitted a survey during a certain period.
The header of the report shows all 52 weeks in a year and its displayed like this
<tr><td colspan="2"> </td>
<cfloop from="1" to="52" index="wk"><td class="dspWeek"><a class="date">#wk#<span>Date</span></a></td></cfloop>
However, know the user wants a rollover date functionality that displays the date of when the user submitted the form.
If I pull distinct dates from a query how would I match it with the title headers on the report?
Also if there aren't any dates to match with the period it should display something like "no surveys submitted"