Hi all, Is there a way to find days difference between 2 date fields on the transaction using search? for ex: I have {shipDate} on Sales Order header and a {custom ship date} (custom transaction line field) on the Sales Order line. I need to write a search to compare the {shipDate} and {custom ship date} and find the days difference. Is this something possible in Search?

You can try Formula Numeric in results ABS(ROUND({shipDate}-{custcol_ship_date})) , set mainline to false.

Thanks @tuli , let me give it a try