On Fri, Jan 28, 2011 at 11:45 AM, Adam Bourg <[email protected]> wrote: > > I'm trying to figure out how to subtract two dates and return the number of > days between then. > > My dates are cprAdultExp, which is a database column, I typically write it > as: #dateformat(cprAdultExp,"mm/dd/yyyy")# > > The other is Now() > Which I also format as: #dateformat(Now(),"mm/dd/yyyy")# > > What's the easy way to do this?
http://www.cfquickdocs.com/cf9/#datediff -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
