How to get difference between two dates in hours using different dates format.

[MayurGavhane]

Hello Everyone,

I am trying to get difference between two dates in hours, but I have two diff dates format and not getting expected output.

I have attached my code and dates format above.

Date1 - 2023-08-12 17:53:59

Date2 - Aug-14-2023 18:30:00

Script-

var start = new GlideDateTime("2023-08-26 09:00:00");
var end = new GlideDateTime("Aug-08-2023 01:30:00");
var dur_seconds = gs.dateDiff(start, end, true);
var dur_hours = Math.round(dur_seconds / 3600);
gs.print(dur_hours);

[Sandeep Rajput · Accepted solution]

@MayurGavhane I made some changes in your code and managed to get the right results.

var gdt = new GlideDateTime();
var start = new GlideDateTime("2023-08-26 09:00:00");
var end = 'Aug-08-2023 01:30:00';
gdt.setDisplayValue(end, "MMM-dd-yyyy HH:mm:ss");
var dur_seconds = gs.dateDiff(start.getDisplayValue(),gdt.getDisplayValue(),true);
var dur_hours = Math.round(dur_seconds / 3600);
gs.print(dur_hours);