Date Range Relationship

[ddinisco]

I need to relate a group records to a portal by a date range of any record for 'this week' (monday-friday). Each record will have a date field, but I was looking for a slick way to create the key on the other side of the relationship.

If Wed...date-1, date-2, date, date+1, date+2.

Don't mind writing the calc, just don't want it to be a slow field to calculate.

Thanks in advance

David

[mr_vodka]

Create a calc as such.

Let ( d = Get ( CurrentDate );

         d - DayOfWeek ( d ) + 2 & ¶  &  d - DayOfWeek ( d ) + 6 

      )

Then your keys for your relationship of the portal will be something like this.

cDateRangeCalc ≤ RecordDate

cDateRangeCalc ≥ RecordDate