Good Morning,
I am hoping someone can help me. I would like to establish a query that notifies me of upcoming expiration dates 2 months before the true expiration. The formula I have constructed is as shown but it doesn't seem to pull the data and I receive an error message. Notify: IIf([(Expiration Date) Next Review Date]-Date()=80,"Review Needed","")
I appreciate any help I can receive. Thank you!
I am hoping someone can help me. I would like to establish a query that notifies me of upcoming expiration dates 2 months before the true expiration. The formula I have constructed is as shown but it doesn't seem to pull the data and I receive an error message. Notify: IIf([(Expiration Date) Next Review Date]-Date()=80,"Review Needed","")
I appreciate any help I can receive. Thank you!