COE(Close) date must not be in future and must be after sales date.The COE date is in DATETIME and Sales date is in Date format in table. So I created a rule as SALES Date] IS NOT NULL AND SALES Date] <= toDate((COE DATE]), but the Monitoring project is failing when added this rule on sales date
Page 1 / 1
Hi
Thank you for your question.
- As a first step to investigate the issue, I would suggest ‘Test Rule’ functionality to make sure all the conditions are checked and the rule result is as expected. For example, make sure that if condition is met, then the rule considered valid/invalid. Also, what happens if the COE date is after Sales date, but in the future?
- If you test the rule and everything performs, as expected, the next step will be to check the error message of why the Monitoring Project is failing.
Please let me know if you have any other questions!
Kind regards,
Ekaterina

Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.