> Then you should be able to replicate the functionality of your CF
statement
> with the Access functions DatePart(), DateDiff() and Now().
I had considered this, but the actual code requires an if statement
<cfif datecompare(createdate(year(now()), month(date), day(date)), now())
LTE 0>
#abs(datediff("D", createdate(year(now()) +1, month(date), day(date)),
now()))#
<cfelse>
#abs(datediff("D", createdate(year(now()), month(date), day(date)),
now()))#
</cfif>
to take into account the date having already occurred in this year and
therefore needing to compare with next years date and my access coding isn't
up to the task. If you could point me in the correct direction... :-)
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
