Looking for a way on a saved search to filter out the following scenario This will return only Sales Orders where the Last Modified Date is different from the Created Date — in other words, orders that have been updated since creation. Trying with a formula numeric and its not working. Any ideas? CASE WHEN {createddate} != {lastmodifieddate} THEN 1 ELSE 0 END

Try adding to_date before each date field

outcome: ended up using Formula (Text), and worked as a Y/N (just wouldn't work as a 1 or 0 for some reason) 🤷

Please try this formula CASE WHEN ABS(TO_DATE({datecreated}) -TO_DATE({lastmodifieddate})) > 0 THEN 1 ELSE 0 END