Dateadd formula for crystal reports

[records333]

Hello All,

I thought I nailed the code but records that I know should return aren't.

My goal is to capture appointments scheduled 8 days from currentdate;

{table.contact_date} in dateadd('d',8,CurrentDate)to currentdate

 

[pmax9999]

What is it that isn't working?

Is it possible that records are being dropped because of Inner Joins to tables that have no data for the records you believe are missing. Alternatively, is it possible that your results are being impacted by Null values in columns referred to in your Record Selection or other formulas.

You haven't given us much to work with, but they are a couple of obvious places to look.

Cheers
Pete