what can i do to change this form so that it will only find records from previous weeks..

code:

---

<FORM ACTION="FMPro" METHOD="get" name="prevtimecard" target="prevtimecard">

<INPUT TYPE="hidden" NAME="-db" VALUE="timecards.fp3">

<INPUT TYPE="hidden" NAME="-lay" VALUE="Form View">

<INPUT TYPE="hidden" NAME="-sortfield" VALUE="Begin Week">

<INPUT TYPE="hidden" NAME="-sortorder" VALUE="descending">

<INPUT TYPE="hidden" NAME="-format" VALUE="prevtimecard.html">

<input type="hidden" name="-Max" value="10">

<INPUT TYPE="hidden" NAME="First Name" VALUE="[FMP-Cookie: firstname , raw]">

<INPUT TYPE="hidden" NAME="Last Name" VALUE="[FMP-Cookie: lastname , raw]">

<INPUT TYPE="hidden" NAME="-find">

</form>

---

the database has a field called begin week which is the date of the first day of the week (monday) how can i exclude the current week from the find...

In the database, create a calculation field that generates a value based on the number of weeks old it is.

Now perform the search on this new calculation field.

thanks man, worked like a charm.