Capturing Expiring & for Retest This Month

[Lola]

Hello All,

 

How can I capture all the materials that are going to expire and for retest this month.

My problem is with my present graph relationship (Retest) it will not capture all the materials that are due for retest this month. it only capture today's date

and future dates and also it captures the next month dates same with my expiry relationship.

I have attached the file that Im working on for your reference

 

Thank you so much..

Retest_Expiry.fmp12

Edited November 24, 2017 by Lola

[doughemi]

See if this helps

Retest_Expiry_dh.fmp12

[Steve Martino]

You don't provide much context about what you expect to happen.  Just based on looking at your file, I'm curious as to why you chose this path of 2 relationships to dashboard via a 'Constant' (1).   This is more of an outdated approach as now you can use the Cartesian relationship to do the same thing.

 

I guess your goal is to display what is due for retest and what is about to expire on your dashboard?  It might be easier just to ditch all the relationship hoops and use 2 self join relationships with filtered portals.

As a side note, you may want a rolling expirations/retest dates, so on the last day of the month you know what's happening tomorrow.

Modified file

Retest_ExpiryModSM.fmp12

Edit:  I see doug posted the same time as me :)...2 different approaches.

Edited November 24, 2017 by Steve Martino

[Lola]

Thanks Dough & Steve...I really appreciate it...

[Steve Martino]

Changed file to rolling 30 days, from today to 30 days into the future, using Relationship rather than filtered portal.

Retest_ExpiryModSM2.fmp12

[Lola]

Hi Steve,

Thank you for the file.