How to get the date includes the committed and today n saved search

Create a saved search and add the necessary filters.

Then in the summary of criteria add the following code. Here we have checked the last committed date as 12 days ago for the Item Statua as A, B, C or O. If the status is S then last committed date is 43 days ago.

….  [“formulanumeric: case when {quantity}={quantitycommitted} then 1 else 0 end”, “equalto”, “1”],

….

 [“customermain.email”, “isnotempty”, “”],                       

“AND”,                       

[[[“max(item.custitem_aha_item_status)”, “is”, “A”], “OR”,                       

[“max(item.custitem_aha_item_status)”, “is”, “B”], “OR”,                       

[“max(item.custitem_aha_item_status)”, “is”, “C”], “OR”,                     

  [“max(item.custitem_aha_item_status)”, “is”, “O”]], “AND”,                     

  [[“max(formulanumeric: CASE WHEN TO_DATE({linesystemnotes.date})=TO_DATE({today}) – 11 THEN 1 ELSE 0 END)”, “equalto”, “1”]]],                       

“OR”,                       

[[“max(item.custitem_aha_item_status)”, “is”, “S”], “AND”,                       

[“max(formulanumeric: CASE WHEN TO_DATE({linesystemnotes.date})=TO_DATE({today}) – 42 THEN 1 ELSE 0 END)”, “equalto”, “1”]]