Creating an "Overdue" formula 1

[genericjanedoe]

I have created a database (In Approach 97) for capturing and tracking projects and I need to create a formula which will find all records where the project delivery date falls within 30 days of the current date.

I'd be grateful for any help on this. Thanks

 

[paulbent]

In Find mode, enter this as the find condition into the delivery date field:

>= @Today() - 30 & <= @Today() + 30

You can save it as a named find by overtyping <Current Find/Sort> in the dropdown list on the Action Bar.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk