Formula to show records between start and scheduled implentation date

[gingerwelshguy]

Hi there ,

I am using Crystal 11 and would like a formula please to show the following between two dates;

If difference between the submit date (01/05/2014) and Implementation date (04/05/2014) is 7 days or less then show records, if greater than 7 days please ignore.

Im new to this so any suggestions woold be welcome

Thanks

 

[pmax9999]

In the Record Selection formula, try:

{YourTable.ImplementationDate} - {YourTable.SubmitDate} < 9

Cheers
Pete

 

[gingerwelshguy]

Hi Pete - Thanks for this formula, it worked, many thanks for your help

 

[pmax9999]

You're welcome.

And of course the formula should have been: {YourTable.ImplementationDate} - {YourTable.SubmitDate} < [highlight #FCE94F]7[/highlight]

Regards
Pete

 

[gingerwelshguy]

Hi Pete - I did wonder why it was showing 9 rather than 7 days...thanks once again