Setting View Criteria

Gentleman,

I�m wondering if you can help solve a problem creating a custom view in Zoho Creator.

The application named �Chard Marketing Inc.� is used to collect reports on product lines of my customer.

http://creator.zoho.com/tomwhita/chard-marketing-inc-

The �store call report� form is used to collect the data. Management of the company would like to be able to see a view of product lines that have not been serviced in the preceding two weeks. I have generated a view that shows all records with an �Added Time� of two weeks or older but this does not solve the need as new records will not be displayed.

What deluge can I write to do the following:

Find all unique instances of �store� and �Line_inspected�.
If the �added_time� of the most recent record of each paring is older than two weeks show in view �Overdue�

Please let me know.

Thanks

Tom