Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get difference between two dates in netsuite?

I m new to netsuite ,i have to find difference between two dates in netsuite. How can i get the difference of two dates in netsuite through scripts.help me,Thanks.

like image 944
user3585325 Avatar asked Mar 18 '23 05:03

user3585325


1 Answers

(I) Get the Difference of Two Date Fields Using an SQL Expression

  1. Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
  2. Create the Custom Fields

Custom Field 1.

Label = Date Created
ID: datecreated
Type: Date
Store Value: True
Applies To: Customer
Display > Subtab: Main

Custom Field 2.

Label: Date Closed
ID: dateclosed
Type: Date
Store Value: True
Applies To: Customer
Display > Subtab: Main

Custom Field 3.

Label: Days Open
Type: Date
Store Value: False
Applies To: Customer
Display > Subtab: Main
Validation and Defaulting > Formula: T
Formula field: {dateclosed}-{datecreated}

  1. Pull up any Customer record > Fill out the custom fields.

For example:

Date Created = 9/1/2014
Date Closed = 9/3/2014

  1. Click Save.
  2. Days Open field should show the value of 2.

(II) Calculate the Difference between a Date/Time field and a Date field Using Formula

The following formula will give you the difference in days. You can add this to the results tab of your saved search.

Formula(Numeric): ROUND({ID of date field}-{ID of other date field})

Note: Either field can be used for the date/time field value.

(III) Using SuiteScript Code

function date_difference(date1, date2) {
    var timeDiff = Math.abs(date2.getTime() - date1.getTime());
    var diffDays = Math.ceil(timeDiff / (1000 * 3600 * 24)); // Get 1 day in milliseconds
    return diffDays;
}
like image 175
Rockstar Avatar answered Mar 26 '23 03:03

Rockstar