Jump to content

Relation by range of date


Tpaairman

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

Recommended Posts

Here's the background - I have a file to track bills due for a regular pay cycle every two weeks. One table is the bill pay date, the other is the list of bills.

What I'm trying to do is this: I will have two dates on the paydate side, which would be the pay date and a start date which would be one day past the last paydate's date, so a start and end date for that pay clcle. Then on that page would be a portal of all of the bills that have due dates within that date range. So when I enter a new bill on the bill table side, the portal in the paycycle side would list all of the bills that have due dates after the start date, but prior to the end date.

I would not entirely be opposed to doing this with a script, but I would rather do it with relationship and portal if possible.

Link to comment
Share on other sites

Take a look and see if you can make the connection, to remake it works with dates instead:

http://www.newcenturydata.com/downloads/filter.zip

Bear in mind the template is overkill compared to you situation, but when you get the gist of it, should it be obvious what to do in your case.

--sd

Link to comment
Share on other sites

This topic is 6074 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
×
×
  • Create New...

Important Information

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