Today's Date Minus Record Date

[mikeap]

I have a date created field and I want to know how many days it's been since that date until now. How can I do that? Would I calcuate that in the SQL string?

[MrBoston]

The DateDiff function should give you what you want.

#DateDiff('d','10/1/2006',Now())#

[Sankalan]

You can find the details about the DateDiff function from this link:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=C...

Thanks

Sankalan
(www.mindfiresolutions.com)