Skip to main content

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 
 

Hi ​@Achavva , 

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