Define Portals with a Equation

[Joseph31]

Hi all,

I need to make a portal that gets it's info from a simple equation.

Ex:

I have a table called "Premiums" Here I enter next premium dates manually. What I would like this portal to do is; to only display premium payments that are 30 days coming.

Meaning only show me from todays date - 30 days = to premium due date.

Help please.

Joseph

[Raybaudi]

Meaning only show me from todays date - 30 days = to premium due date.

I think that you wish to show premium due date that is todays + 30... (the premiums that I'll have to give)

But the solution is the same.

In the main table, the table that contains the field "today" = Get(CurrentDate) (NOT STORED), make a new calc field:

today + 30

and make a relashionship from this and the date of "Premiums" table

[Joseph31]

Ok I see that...

But I need it to show everything that is upto +30 days from todays date.

Joseph

[Raybaudi]

So change the "=" in the relashionship with ">="

and add a new one, so that today <= premiumDate.

the relashionship will became:

premium payments >= premiumDate

AND today <= premiumDate

where "premium payments" is the calc that I said to you (today + 30)