title: NetSuite Saved Search to Calculate time elapsed from system note changes
body: <p>I want to calculate the time from when one field is set in the system notes to when it is changed again in a Transaction saved search.</p>
  
  <p>Here are the 2 case formulas I created to get the date and time of when this field was set to True and when it was changed to false.  </p>
  
  <p>case when {systemnotes.field} = 'Problem Order' AND {systemnotes.newvalue} = 'T' then {systemnotes.date} end</p>
  
  <p>case when {systemnotes.field} = 'Problem Order' AND {systemnotes.newvalue} = 'F' then {systemnotes.date} end</p>
  
  <p>I want to find the difference between the 2 {systemnotes.date}. How do I do this? </p>