thong127

Determining Expiring & for Retest This Month

Discussion created by thong127 on Nov 22, 2017
Latest reply on Dec 31, 2017 by greatgrey

Hello Everyone,

 

I have two Tables Company Dashboard and Materials

I want in my Dashboard to show an alert showing the number of materials for retest and expiring materials for this month. My problem is if I put the date today (November 22, 2017) in my expiry or retest date field it will show me the alert but if I will put let say the date tomorrow or any date not today it will not show me the alerts.

 

Please find attached file that Im working.

 

Thanks

Attachments

Outcomes