Here's a complicated one for you: Saved Search......
# administration
p
Here's a complicated one for you: Saved Search... Need to find out the time between to system notes dates. Scenario: [FieldA] is a drop down, and an order will progress thought the dropdown 'stages' (1>2>3>4>5) We need to know how long the order was in stage1. Only way I can think of is to get the system notes datetime of when it was [stage1] and compare that to when it went to [stage2] Cant think how to do this is a Formula field. Only need to be dynamic, and we dont want more custom fields to hold the 'stage1 'set' datetime value (which would be another approach) Any ideas will be much appreicated. Thanks
r
I went to SuiteAnswers and searched on “search formula time difference” and found many answers. Article #72386 looks to be a pretty close match to what you are looking for.