0

I'm wondering if there is a way to get the difference between custom date formulas on a saved search.

1st Formula (Date/Time):

CASE WHEN ({systemnotes.newvalue} = 'Pending Fulfillment') THEN {systemnotes.date} END

2nd Formula (Date/Time):

CASE WHEN ({systemnotes.newvalue} = 'Billed') THEN {systemnotes.date} END

Both these formulas give me the correct date I need, but now I need to figure out how to get the 2nd formula minus the 1st formula.

Is this possible?
I've tried:

Formula(Numeric):

((CASE WHEN ({systemnotes.newvalue} = 'Billed') THEN {systemnotes.date} END) - (CASE WHEN ({systemnotes.newvalue} = 'Pending Fulfillment') THEN {systemnotes.date} END))
jasie
  • 2,192
  • 10
  • 39
  • 54
Alyssa Jean
  • 11
  • 2
  • Does this answer your question? [How to get difference between two dates in netsuite?](https://stackoverflow.com/questions/26334088/how-to-get-difference-between-two-dates-in-netsuite) – jasie Jul 27 '21 at 07:50
  • This should work: (CASE WHEN {systemnotes.newvalue}='Billed' THEN {systemnotes.date} END) - (CASE WHEN {systemnotes.newvalue}='Pending Fulfillment' THEN {systemnotes.date} END) – Martha Jul 28 '21 at 21:25

0 Answers0