Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved Search Formula: Date/Time Difference: Days - Hours - Minutes - Seconds
This sample is using a Case Saved Search which gets the difference between case closure vs case creation (without excluding business days)
Formula:
| DAYS | TRUNC({closed}-{createddate}) |
| HOURS | MOD(TRUNC(({closed}-{createddate})*24),24) |
| MINUTES | TRUNC(60*((({closed}-{createddate})*24)-TRUNC(({closed}-{createddate})*24))) |
| SECONDS | ROUND(60*((((({closed}-{createddate})*24)-TRUNC(({closed}-{createddate})*24))*60)-TRUNC(((({closed}-{createddate})*24)-TRUNC(({closed}-{createddate})*24))*60)),0) |
[ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"381","title":"Saved Search Date Difference Days Hours Minutes Seconds.png","width":"933","data-attachmentid":440576}[/ATTACH][ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"303","title":"Saved Search Date Difference Days Hours Minutes Seconds Sample Results.JPG","width":"800","data-attachmentid":440578}[/ATTACH]
0