Jump to content

Need Help with Canned Searches


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

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8589 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.