Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add 14 days?

Status
Not open for further replies.

bloomlight

IS-IT--Management
Jun 12, 2006
149
US
Crystal Report question: How to add 14 days to the StartDate?

I need to make a report which will show the date (mm/dd/yyy) of our client's (startdate + 14).

Here is what I needed:

Name StartDate 14-days
====== ========= =======
Client#1: 12/01/2011 12/15/2011
Client#2: 12/10/2011 12/25/2011
Client#3: 01/05/2012 01/19/2012
Client#4: 01/25/2012 02/08/2012

We have startdate in our database. How to make a formula to show the 14days? Your help will be greatly appreciated.
 
{table.StartDate} + 14

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Hi hilfy, when I try {table.StartDate} + 14, the message came up saying that "A boolean is required here". How to fix that?

Thanks.
 
I found the way how to do it. Used dateAdd function.
Thanks Again.
 
hilfy's solution will work. It sounds like you were placing it in the wrong formula area.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top