Display Date Only - By Year

Question

This is probably simple but I can't find a solution...

Maybe brain not in right place...

I have multiple dates... ie data entry on different dates...

And want to search these entries... And display only the year...

ie... Data entered in 2011 and 2012...

Want to display output of "2011" and "2012" to break down the dates...

cfquery name="staty" datasource="fpb">

select * from inspid

where inspectorid = #session.inspuser_id#

order by inspdate desc

cfquery>

Output - just the years - from multiple dates...

Seems simple - but I can't get it in my head...

Thx

Merle_Hanson · Accepted Answer

"I can't find a solution" - How hard have you tried? Try Googling [...]

Wow. Didn't know you could do that.

--

Adam

Thanx for the sarcasim...

Yes I consider google my textbook...

Answer here...

select distinct year(inspdate) AS yydate from inspid

where inspectorid = #session.inspuser_id#

</cfquery>

#yydate#

</cfoutput>

Coding was blurred in my head...

Dan_Bracuk · Answer

The way to select just the year portion of a date field depends on the type of db you are using.

Sign up