Formula to display records from last 7 days 1

[makk07]

Hi,

I have a report with customer name field from one database table and date field with null values from a different database table.

I want to display only records from last 7 days by grouping on customer name field?

Please anybody let me know how to do that.

Thanks in advance

 

[dgillz]

In the record selection formula:

{YourDateField} in Currentdate to Dateadd("d",-7,Currentdate)

You didn't really say how you wanted to treat nulls, so if you want something, please explain it.

Also please alwayspost your Crystal version, correct answers vary by version. The above formula for example will work in crystal 8.5 and newer only.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[makk07]

I really appreciate it. Thank you so much. For your information i am using Crystal Reports XI Release 2.