Technical Questions: adding days to date excluding weekends

Print Page | Close Window

adding days to date excluding weekends

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10260
Printed Date: 05 May 2024 at 7:12am

Topic: adding days to date excluding weekends

Posted By: Amanda_K
Subject: adding days to date excluding weekends
Date Posted: 15 Jun 2010 at 7:00am

I am trying to take a "Start Date" and add # of days, but would like to subtract weekends.

example:

DateAdd("w", {number of days to add},{@Start Date})

(this will add the days from the start date, but I can not get it to not count the weekends)

Any Ideas?

-------------
Amanda

Replies:

Posted By: Amanda_K
Date Posted: 15 Jun 2010 at 9:01am

I found the answer here: http://www.kenhamady.com/form17.shtml - http://www.kenhamady.com/form17.shtml . Thanks!

-------------
Amanda

Print Page | Close Window