Help Avoiding a Double Redirect

[James Currie]

I have a link on my index page that leads to a list of upcoming events. The events are displayed in a page that uses inline frames. Apparently Filemaker doesn't "serve" the content of the frames (in the sense that something like [FMP-CurrentDate] would load on the parent frame, but not on one of the two iframes).

My solution was to use a redirect on one of the two iframes. The problem: I want that frame to automatically load a list of upcoming events. To do that I'm using FMP-CurrentDate. The first redirect brings up a page that has a hidden field for FMP-CurrentDate. To get the records that are equal or greater than the current date (ie: the upcoming events), I'm using another redirect to to a search with -op = gte and the field "date" = [FMP-CurrentDate].

This works fine, but seems like a clumsy way to accomplish things. Any suggestions?

[Garry Claridge]

I've just had a challenge where I needed to display all quotes created in the last 30 days.

So I created a calculated field which checked the quote date against the (currentdate - 30) and returned either 'current' or ''. I was then able to search for all 'current' quotes.

Hope this is of interest.

Garry