Jump to content

This topic is 8783 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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...

Posted

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.

This topic is 8783 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.