elvis_impersonating_penguin Posted February 6, 2001 Posted February 6, 2001 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...
Vaughan Posted February 6, 2001 Posted February 6, 2001 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.
elvis_impersonating_penguin Posted February 7, 2001 Author Posted February 7, 2001 thanks man, worked like a charm.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now