Find the number of days

[auburnfan]

OK I am using CR 8.5.
What I need is to be able to find the number of days since a customer called last.

I want to be able to have my paramater as enter say 30 and it will show me every customer that has not called within 30 days. I know I could just enter the the date manually, but the people who will be running the report want it as easy as possible.
Any suggestions would be appreciated.
Thanks,
Jeff

 

[Madawc]

Make a formula field with something like

DateDiff ("d", {datecalled},  currentdate)

Try displaying this against your data, just to confirm you are getting what you want.

Then in your selection, check for it being 30 or more.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10