April 16, 200718 yr 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?
April 16, 200718 yr 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
April 16, 200718 yr Make that: cDate (calculation, date result) = gDate + 7 And the relationship: cDate ≥ Child::Date AND gDate ≤ Child::Date
Create an account or sign in to comment