moyedokun
asked on
Finding out number of weeks by date range
I have a record with a date range. Is there a way to determine the number of weeks that is included in the date range?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yep sir.. agree with you.. i was asleep when I wrote that code..
ASKER
I get an error. It is telling me that ww is undefined.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check this out:
http://www.cfitools.com/isite/details.cfm?ItemID=170
http://www.cfitools.com/isite/details.cfm?ItemID=170
You can do something like this:
<cfset sDate = "07/23/2006-07/20/2006"
<cfset iWeeks = datediff(ww,listLast(sDate
iWeeks should give you the difference in weeks..