The CreatorCon Call for Content is officially open! Get started here.

how to check if two dates are equal using gs.dateDiff function ?

Go to solution
venishawakodika
Giga Contributor

‎05-29-2017 09:42 PM

how to check if two dates are equal using gs.dateDiff function ?

what does it return if dates are equal ?

0 Helpfuls
  • 13,806 Views
1 ACCEPTED SOLUTION

Go to solution
Shishir Srivast
Mega Sage

‎05-29-2017 09:45 PM

Hi Vineetha,



Please find below details and helpful link.



calDateDiff(String, String, boolean)Calculate the difference between two dates using the default calendar. Note: Calendars are now legacy. If Schedules are being used, see Calculate Duration Given a Schedule.


dateDiff(String, String, boolean)


Calculates the difference between two dates. This method expects the earlier date as the first parameter and the later date as the second parameter; otherwise, the method returns the difference as a negative value. Note: Use getDisplayValue() to convert the strings to the expected format.


3.13.1 Input Fields

Parameters:


  • startDate - a starting date to compare, in the current user's date format.
  • endDate - an ending date to compare, in the current user's date format.
  • boolean bnumericValue - true to return difference in number of seconds as a string, false to return difference in the format ddd hh:mm:ss.

3.13.2 Output Fields

Returns: if boolean bnumericValue is true, the difference in number of seconds; if false, the difference in the format ddd hh:mm:ss.


3.13.3 Example

For more examples, see Setting the Duration Field Value.


// Given two date/times as DateTime objects // Set the values this way to ensure a consistent input time var date1 = new GlideDateTime(); var date2 = new GlideDateTime(); date1.setDisplayValueInternal('2014-01-01 12:00:00'); date2.setDisplayValueInternal('2014-01-01 13:00:00');   // Determine the difference as number of seconds (returns a string) // Use getDisplayValue() to convert the string to the format expected by dateDiff() var diffSeconds = gs.dateDiff(date1.getDisplayValue(), date2.getDisplayValue(), true);   // JavaScript will coerce diffSeconds from a string to a number // since diffSeconds is being compared to a number var msg = (diffSeconds <= 0) ? ' is on or after ' : ' is before '; gs.print(date1.getDisplayValue() + msg + date2.getDisplayValue())


GlideSystem Date and Time Functions - ServiceNow Wiki


http://wiki.servicenow.com/index.php?title=Calculate_Duration_Given_a_Schedule


View solution in original post

6 REPLIES 6

Go to solution
sachin_namjoshi
Kilo Patron
Kilo Patron

‎05-29-2017 09:48 PM

Please check below posts which should help you.



Help needed with gs.dateDiff() to calculate difference between dates



Regards,


Sachin