get number of days between 2 dates

Hareesha
Tera Contributor

I have 2 dates in on form and calculated field. i have to get number of days between 2 dates. I wrote a script but its returning 20 days. I need only the count not 'days' word. Can anyone help me.

3 REPLIES 3

OlaN
Giga Sage
Giga Sage

Hi,

This community post might help you.

AnveshKumar M
Tera Sage
Tera Sage

Hi @Hareesha ,

You can use  getDayPart() or getRoundedDayPart() methods , to get only the days part without "days" string. Try running the following script to understand this better.

 

 

var present = new GlideDateTime();
gs.print(present);

var future = new GlideDateTime();
future.addDaysUTC(1000);
gs.print(future);

var dur = GlideDateTime.subtract(present, future);
gs.print(dur);
gs.print(dur.getDayPart());

 

 

 

Thanks,

Anvesh

Thanks,
Anvesh

Ankur Bawiskar
Tera Patron
Tera Patron

@Hareesha 

Please share your script here.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader