RE: Business days from Dates PLEASE HELP!!!!
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 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: President's Day, Thanksgiving, etc.) To work with this, you could modify the logic as follows: Hope this helps! - Original Message - From: "LANCASTER, STEVEN M. (JSC-OL) (BAR)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 23, 2002 1:56 PM Subject: Business days from Dates PLEASE HELP > I have a Database it has a date in one of the columns. I take that date and > another column in the table which is just an integer an use the DateAdd > function to come up with a second date. > > I have: > > date1, duedate(created from the DateAdd function), days_until_it_is_due > > Now I need to give these people X amount of business days based on > days_until_it_is_due to come up with a proper due date. Can anyone please > help me or tell me where to start.. > > Steven Lancaster > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Business days from Dates PLEASE HELP!!!!
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: President's Day, Thanksgiving, etc.) To work with this, you could modify the logic as follows: Hope this helps! - Original Message - From: "LANCASTER, STEVEN M. (JSC-OL) (BAR)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 23, 2002 1:56 PM Subject: Business days from Dates PLEASE HELP > I have a Database it has a date in one of the columns. I take that date and > another column in the table which is just an integer an use the DateAdd > function to come up with a second date. > > I have: > > date1, duedate(created from the DateAdd function), days_until_it_is_due > > Now I need to give these people X amount of business days based on > days_until_it_is_due to come up with a proper due date. Can anyone please > help me or tell me where to start.. > > Steven Lancaster > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Business days from Dates PLEASE HELP!!!!
I have a Database it has a date in one of the columns. I take that date and another column in the table which is just an integer an use the DateAdd function to come up with a second date. I have: date1, duedate(created from the DateAdd function), days_until_it_is_due Now I need to give these people X amount of business days based on days_until_it_is_due to come up with a proper due date. Can anyone please help me or tell me where to start.. Steven Lancaster __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
