Relationship based on date range

[merkaba22]

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?

[mr_vodka]

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

[Ender]

Make that:

cDate (calculation, date result) = gDate + 7

And the relationship:

cDate ≥ Child::Date

AND gDate ≤ Child::Date

[merkaba22]

That's pretty nice guys:)

Thanks alot!