Passed Date Portal Filter

[falkaholic]

Hi,

I'm trying the make a portal that only shows tour dates to come, and hide passed ones. For example, if a band is having a tour date on 07/16/03, it will show in the portal, once 7/16/03 passes, so will the row in the portal.

The problem is, there is no way to have a relation with dates you can't index. Since there child records have to be static dates and not calculations. As well, tour dates could be a year or more in the future, so having a calc in the parent file of a long date range in the only way I can figure this - and I don't like that way

Anyone else got ideas?

[ralph.nusser]

The must read for date ranges is:

http://www.onegasoft.com

The best i've seen in the last 4 years.

With the calculations developed from Mr. Edoshin your problem is solved.

[djgogi]

The attached files solves this problem.

Only thing that you have to implement is update of todaydate field in Master (tourTest) file:

Thru triggered calculation or with scripts (when accessing the portal layout, or at opening of db etc.)

Dj

falkaholic .zip

[falkaholic]

Cool. Thanks alot.

I still have to get my head around how it works and implentment it.

Thanks again.