Show records where one date is X days after another date

[Charlie Kilo]

I have two fields: INDATE and OUTDATE. I would like to see all the records in my database where OUTDATE is more than 15 days after INDATE, but I have no clue how to achieve this! Can anybody help me?

Thanks!

Frosty

[Raybaudi]

Hi

first you'll need to create a new calculated field, result number, with calc:

OutDate - InDate

Then you can find your records by entering, while in Find Mode: > 15 into that new field.