I have a field with a date in timestamp format: 12/6/2011 12:39:33 PM. That field is dateEntered.
I need to provide a dynamic report of Records by Month and YTD.
Total in 2011: 64
I know I somehow need to incorporate the splitting up of the dates by month and year... Something like:
<cfquery name="qry_getRecords" datasource="#request.DSN#"
SELECT dateEntered from sa_Requests
ORDER BY dateEntered
<cfset myDate = qry_getRecords.dateEntered
<cfset theDay = listGetAt(myDate,1,"-")>
<cfset theMonth = listGetAt(myDate,2,"-")>
<cfset theYear = listGetAt(myDate,3,"-")>
But I can't figure out if I do this somehow on the query side, or the output side (and if so, how to group). I'd love some suggestions/examples/advic
e. Thanks so much.