2019
  February
      Day

<cfquery name="nchklist" datasource="#fds#">
    SELECT year(chkdate) AS Year, month(chkdate) AS month, day(chkdate) AS day, vcheck
    FROM vchk
    where vid = '#vid#' and final = 1
    ORDER BY year, month, day
</cfquery>

<cfoutput query="nchklist" group="year">

    <cfoutput group="month">
        #monthAsString(month)#

        <cfoutput group="day">
            <a href="create_report.cfm?vcheck=#vcheck#">View</a> :  DateFormat(chkdate, 'dddd - mmmm d, yyyy')#<br>
        </cfoutput>

    </cfoutput>

</cfoutput>

ORDER BY year(chkdate), month(chkdate), day(chkdate)

SELECT year(chkdate) AS TheYear
        , month(chkdate) AS TheMonth
        , day(chkdate) AS TheDay
        , vcheck
 FROM   vchk
 WHERE  vid = <cfqueryparam value="#vid#" cfsqltype="cf_sql_varchar">
 AND    final = 1
 ORDER BY TheYear, TheMonth, TheDay