Report Design: Correct Syntax for my formula

Print Page | Close Window

Correct Syntax for my formula

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=7894
Printed Date: 07 May 2024 at 9:16am

Topic: Correct Syntax for my formula

Posted By: niko
Subject: Correct Syntax for my formula
Date Posted: 02 Oct 2009 at 12:00pm

What would the correct syntax be if I needed to see all the info for the last 60 days?

Example: I need to know all the 60 day old invoices from invoice.armast

thanks!

Replies:

Posted By: DBlank
Date Posted: 02 Oct 2009 at 12:46pm

in the select expert:

{invoice.armast} in dateadd('d',-60,currentdate) to currentdate

Posted By: niko
Date Posted: 02 Oct 2009 at 1:51pm

Thanks so much!

Print Page | Close Window