flyingmonkey Posted November 13, 2000 Posted November 13, 2000 I have a database that I am custom web publishing. It is searched most often by date and more specifically with the "gretaer than" search operator selected and x number of days ago enetered. I would like to add a canned or predetermined search with the click of a button since most people want to see the last 2 or 3 days of postings. So far I have created a field in the database that is a calculation of Todays date minus 2 which gives me the correct date of 2 days ago but I haven't been successful in getting the search to execute from the web page. Any help would be appreciated.
Vaughan Posted November 13, 2000 Posted November 13, 2000 Create a calculation field *in the database* that does the calculation -- but use the Status[CurrentDate] not Today as Today only recalculates when the database is opened (a bummer if you leave it running for a week). So now your database has a field in it that has the "age" of the records in days. Create a canned search on this field on your custom html format pages.
Recommended Posts
This topic is 9043 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