Crystal Reports Add days to CurrentDate

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Add days to CurrentDate

Author	Message
azclay Newbie Joined: 02 Aug 2011 Location: United States Online Status: Offline Posts: 1	Topic: Add days to CurrentDate 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.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 02 Aug 2011 at 11:03am
	dateadd('d',3,currentdate)
	IP Logged

plamkin Newbie Joined: 12 Sep 2011 Location: United States Online Status: Offline Posts: 3	Posted: 12 Sep 2011 at 10:31am
	How do I change that to add 3 business days to a CurrentDate? Thank you
	IP Logged

cymruchris Newbie Joined: 12 Sep 2011 Online Status: Offline Posts: 4	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
	IP Logged

plamkin Newbie Joined: 12 Sep 2011 Location: United States Online Status: Offline Posts: 3	Posted: 13 Sep 2011 at 3:00am
	I need to add 3 business (vs. calendar days) to the PrintDate
	IP Logged

plamkin Newbie Joined: 12 Sep 2011 Location: United States Online Status: Offline Posts: 3	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.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.033 seconds.