Need help sorting out dates

Thanks again, much appreciated.

andy99 wrote:
> Thanks Ian.
> This is what I wanted.
> One question, if I want to retun the months as alphabitics instead of number should I add <cfif> statement or is there a function for that?
>
> Thanks again

Yes, I'm sure your database date functions could convert the month to an
text name rather then a number. ColdFusion also has a monthAsString()
function that takes the number of a month and returns the string name,
strangely enough.

Thanks Ian.
This is what I wanted.
One question, if I want to retun the months as alphabitics instead of number should I add <cfif> statement or is there a function for that?

Thanks again

Assuming your date column is truly a date column with a date type not a
text column that stores a text string that looks like a date to most
people. Then this will be easy, otherwise it will be much harder and I
would strongly recommend improving your database design.

<cfquery ... name="recSet">
SELECT
year(dateField) AS year,
month(dateField) AS month,
dateField,
nameField

FROM
table

ORDER BY
dateField ASC
</cfquery>

<!---
What that actual functions are for year() and month() will very from
database management system to system. Their documentation is happy to
tell you what they are. All of them have something that handles this
type of conversion.
--->

<cfoutput query="recSet" group="year">
#year#<br>
<cfoutput group="month">
#month#<br>
<cfoutput>
#dateField# #NameField#<br>
</cfoutput>
</cfoutput>
</cfoutput>