Numbers absent 2 weeks back

[#1]

Hi all,

I am working on an application in which I need to find all students which have been absent in the past 2 weeks.

So for example, I'm using the date 30/04/2011 as the End Date and want to flag all students that have been absent 2 weeks back.

So all Absent students from 16/03/2011 to 30/04/2011.

I would like to flag the absent student (Student Number), in the script load.

I have attached the sample .qvw I am working on.

Any idea would be appreciated!

Thank you

[#2]

I've changed the example .qvw a little.

How could I show only dates between the 2 dates input in the Start Date and End Date input box?

I'd like to show only these dates in the chart/pivot.

Thanks

[#3]

ideas?

[#4]

I did some changes in your load script .

Hope that helps.

Philippe