There is a business days calculator on the cflib.org website as a UDF.
--Dharmesh
-Original Message-
From: Scott Van Vliet [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 24, 2002 1:53 AM
To: CF-Talk
Subject: Re: Business days from Dates PLEASE HELP
Steven:
Given that business
Steven:
Given that business days are generally monday thru friday, you can use the
code below (where date, daysUntilDue & dueDate would be values from your
database).
businessDaysUntilDue: #businessDaysUntilDue#
NOTE that this does not cover holidays (such as the US holidays: P
Alex,
Here is how to do it in SQL Server (assuming Saturday and Sunday are not
business days)
Select count(*) as daycount
>From DateTable
Where DateTable.EntryDatetime >= [beginnindate] AND DateTable.EntryDateTime
<= [enddate]
AND ((DateName(dw, DateTable.EntryDatetime) != 'Saturday') AND (DateNa
There isn't a function in SQL server.
For such a function to work everywhere, you would need to tell it
what country you're in & supply data on what holidays are scheduled.
Often, holidays cannot be determined programmatically & are not
known very far in advance.
Reuters has this data somewhere
This might help get you started:
1) get all the dates between 2 dates using something like
SELECT
the_date
FROM
table
WHERE
the_date BETWEEN CreateODBCDate(date1) AND CreateODBCDate(date2)
then
2) on your CFOUTPUT, something like
#the_date#
-Original Messag
5 matches
Mail list logo