Jump to content
Sign in to follow this  
ddinisco

Date Range Relationship

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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