So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years.
I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the specification is 6 months or less from expiration I want to have the "days between" trigger a yellow text to alert me to request a new speciifcation. In other words I want 180 days to be my alert zone , hit 180 days or less go after a new specification.
I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the specification is 6 months or less from expiration I want to have the "days between" trigger a yellow text to alert me to request a new speciifcation. In other words I want 180 days to be my alert zone , hit 180 days or less go after a new specification.