Print Page | Close Window

Add days to CurrentDate

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13952
Printed Date: 03 May 2024 at 10:41am


Topic: Add days to CurrentDate
Posted By: azclay
Subject: Add days to CurrentDate
Date Posted: 02 Aug 2011 at 10:41am
I am attempting to add 3 days to the CurrentDate in a formula for record selection.  I am using the DateAdd function with CurrentDate in the formula.  I keep getting errors.  Can someone point me in the right directions?  Thank you. 


Replies:
Posted By: DBlank
Date Posted: 02 Aug 2011 at 11:03am
dateadd('d',3,currentdate)

Posted By: plamkin
Date Posted: 12 Sep 2011 at 10:31am
How do I change that to add 3 business days to a CurrentDate?
Thank you

Posted By: cymruchris
Date Posted: 13 Sep 2011 at 12:43am
The easiest way i've found is to use the following in select expert
for the date of the record you want to pull through
 
currentdate + 3

Posted By: plamkin
Date Posted: 13 Sep 2011 at 3:00am

I need to add 3 business (vs. calendar days) to the PrintDate

Posted By: plamkin
Date Posted: 13 Sep 2011 at 3:32am
I got it.  There is probably a much easier/shorter way to do it but it appears to return what I need. 


Print Page | Close Window