jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have a strange database and I need to check some documents which have a due date. So I need to have Alerts were the two dates are 10 days before the today date.
The alerts are always confronting the Date to Resign and the Date Due To with the today() = 22/09/2021. So the first Alert is based on the Date to Resig, while ALERT 2 it should be based on Date Due to and Alert 1. So I need the result as in column Alert 2 and the reason is:
First row: If in the cell of column Alert 1 is YES automatically in the column of Alert 2 it has to be NO or " ", it doesn't matter as I already have a Alert 1.
Second row: it is in both columns NO because the dates in both columns are not today date +10 days that I Need an Alert, but are far away from 22/09/2021 so not interested.
Third row: the same situation as in row two....I can't do nothing about thouse documents as they have alreay expired.
fourth row: I need a Yes in the Alert 2 column because there is a NO in Alert 1 Column and the Date Due To 01/10/2021 is close to today date (22/09/2021) + 10 days so I need to have the alert because I need to know it 10 days in advance before the date due to 01/10/2021 is in order to renew the document.
Maybe I was not so clear ...still let me know if you need more information.
Thank you
I have a strange database and I need to check some documents which have a due date. So I need to have Alerts were the two dates are 10 days before the today date.
The alerts are always confronting the Date to Resign and the Date Due To with the today() = 22/09/2021. So the first Alert is based on the Date to Resig, while ALERT 2 it should be based on Date Due to and Alert 1. So I need the result as in column Alert 2 and the reason is:
First row: If in the cell of column Alert 1 is YES automatically in the column of Alert 2 it has to be NO or " ", it doesn't matter as I already have a Alert 1.
Second row: it is in both columns NO because the dates in both columns are not today date +10 days that I Need an Alert, but are far away from 22/09/2021 so not interested.
Third row: the same situation as in row two....I can't do nothing about thouse documents as they have alreay expired.
fourth row: I need a Yes in the Alert 2 column because there is a NO in Alert 1 Column and the Date Due To 01/10/2021 is close to today date (22/09/2021) + 10 days so I need to have the alert because I need to know it 10 days in advance before the date due to 01/10/2021 is in order to renew the document.
Maybe I was not so clear ...still let me know if you need more information.
Thank you