Jump to content
Sign in to follow this  
merkaba22

Relationship based on date range

Recommended Posts

If a user defined date is created for one side of a relationship and the other side is defined as a date field for portal records, portal data is displayed for that user defined date.

Is there a way to have a realtionship that returns all records for a range of dates, say, the user defined date through the user defined date + 7 days?

Share this post


Link to post
Share on other sites

You can create a calc field (text) that is as such:

gDate & ¶ & gDate + 7 where gDate is the user entered date in a global date field.

Then for your relationships between this calc field and the Date field on the child side, the two criterias for your relationship are

cDate ≥ Child::Date

cDate ≤ Child::Date

Share this post


Link to post
Share on other sites

Make that:

cDate (calculation, date result) = gDate + 7

And the relationship:

cDate ≥ Child::Date

AND gDate ≤ Child::Date

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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