Filter merged view by latest date entry

[Lost in InfoPath]

Here is the scenario:

A form template contains a repeating table that has a date picker and next
to it a text area where an employee would enter the current status of their
project. Each week, they would go in, select a date and enter a new status.
When I merge the forms, in my merged form view, I only want to see the latest
status that the employee posted. I've tried a number of ways to put a filter
on the date to see if that would work and I'm having issues. For example, I
tried to add a filter function like "if updatedate is greater than max()
......". I'm new to InfoPath so I'm not sure if what I'm trying to do is
possible or not and I do not have a clue how to do it if it is possible. Can
someone please help?

 

[Clay Fox]

merge is tough.

It is available but really hard to find a scenario where it works well
because it is dificult to control.

There are much better solutions for reporting.

Sorting by a date range is difficult to in InfoPath. You have to use the
DateDiff function which would calculate your weekly date range each week.
There are posts on this on http://www.infopathdev.com

I would recomend you check out the Database Accelerator. It would give you
complete reporting capabilities and includes a whole time and project
tracking solution that already has what you are looking for.
http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com