Diiference in date -- from Access

[SSonnier]

Here is whaw I'm trying to do:

I am trying to calculate the difference in years between today's date and a date(year) that I am storing in a database.

How can I pull the year form the query into the datediff function?

Here is the code: The second specifier is causing problems "(#ayear#)"

<cfoutput query="emplist2">
#first_name#'s &nbsp;&nbsp;- &nbsp;&nbsp; #datediff("yyyy",now(), (#ayear#))# Years
</cfoutput>

 

[ecobb]

According to the CF Help files, DateDiff "Determines the number of units by which date1 is less than date2."

datediff("datepart", "date1", "date2")

So, in your code is the value "ayear" going to be greater than Now()? If not, you'll need to switch them. If it's right, try this:

#datediff("yyyy",#Year(now())#,#ayear#)#





Hope This Helps!

Ecobb

&quot;My work is a game, a very serious game.&quot; - M.C. Escher