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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Valid to date of a report

Status
Not open for further replies.

drdredog

Technical User
Sep 6, 2009
1
ZA
I have created a quotation using crystal reports and I am having difficulty inserting a valid to date. I would like to specify a date 30 days from the day that the quote was generated to say that the quote is valid until that date. Please help me solve this problem.
 
Use a record selection formula like this:

{table.quotedate} in {table.quotedate} to {table.quotedate}+30

You can enter this directly by going to report->selection formula->record.

-LB
 
Hi,
If you want something on the report that indicates the valid period of the quote, create a formula like:
@ValidUntil
Code:
{table.quotedate} + 30
then in your page or report footer create a string :
Code:
"This quote valid until " + ToText(@ValidUntil,'MM/dd/yyyy')




[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top