Jump to content

Define Portals with a Equation


Joseph31
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

This topic is 5761 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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.