write a saved search function where the system notes time and date of a field a field is after the system notes time and date of another field

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, it seems you are trying to create a saved search that calculates the time difference between two system notes dates. This can be achieved by using a formula field in your saved search. Here's a general approach: 1. In your saved search, you would need to include the

System Notes: Date

field twice, once for each of the stages you are interested in (stage1 and stage2 in your case). 2. You would then need to set up criteria for each of these fields to capture the correct system notes entries. For example, for the first

System Notes: Date

field, you might set the criteria to

System Notes: New Value

is

stage1

, and for the second

System Notes: Date

field, you might set the criteria to

System Notes: New Value

is

stage2

. 3. Once you have these two date fields, you can create a formula field to calculate the difference between them. The formula might look something like this:

TO_CHAR({systemnotes.date2} - {systemnotes.date1}, 'HH24:MI:SS')

. This will give you the time difference in hours, minutes, and seconds. Please note that this is a general approach and might need to be adjusted based on your specific requirements and the exact setup of your NetSuite account. Also, keep in mind that system notes only capture changes to fields, so this approach will only work if the stages are being changed and those changes are being captured in the system notes.