I have a portal in which I want to filter the portal items to show only the activity of the past 30 days. I know that I can use a selfjoin relationship using the creation date field, but I'm a little stuck on how to calculate the past 30 days into that. Can anyone make any suggestions? Thanks, Ron.

Hi Ron

I haven't got a clue how to set up a relationship directly to find what you want ( not cos there isn't one but just because I am not very experienced).

There is one other possibility though and that would be to use a multi key for your portal.

Set up a self relate on a global to your record id.

Next do a looping script along the lines of

show all records

go to first record

if field creation date>Get(CurrentDate)-30

set your global to recordID

loop

go to record next(exit after last)

if

field creation date>Get(CurrentDate)-30

setfield your global to your global & " :paragraph: " & recordID

endif

endloop

If I am right this would set up your portal based on your global to show all records where the creation date is older than today minus 30 but I havent tested it - and I am only an amateur . What the heck - give it a whirl

Phil

Hi Ron,

Create a calculation (unstored, result of date) with: Get(CurrentDate) - 30

Join Main::aboveCalc on 'less than or equal to' to Self-Join::CreationDate.

See, I knew someone would know the proper way : : :

Phil

Laretta rocks dosen't she. Thanks again Laretta, somehow I know you'd have an answer for me.

Laretta rocks doesn't she.

Yup!