This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

Hi All, I am trying to come up with a formula in my saved search with the following criteria - if Date Modified by -System- was after Date modified by UI then 0 else 1. In my formula I need to look at the timestamp as the day might be same. Can someone help me please? Thank you!

`CASE WHEN (MAX(CASE WHEN {systemnotes.name} = '-System-' THEN {systemnotes.date} ELSE NULL END) &gt; MAX(CASE WHEN {systemnotes.context} = 'UI' THEN {systemnotes.date} ELSE NULL END)) THEN 0 ELSE 1 END`