I have a query ...
SELECT AVG(DATEDIFF(minute, dateasgn, datecomp)) AS diff
FROM tblprob
WHERE priority = 'urgent'
AND datecomp IS NOT NULL
AND status = 'closed'
AND dateasgn >= '#form.startdate#'
AND dateasgn <= '#form.endDate#'
but I only want the business dates (no weekends or nights; just 9AM to 5PM Mon
to Fri)
This is in SQLServer. Any help appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
