calculate the weeks between the dates

siva58 · ‎03-14-2022

calculte the weeks between the two dates by using business rules..

example:

these two are the dates

start date:

End date:

the result(no.of weeks) will be populate in another field,

no.of week:

Baala T · ‎03-14-2022

Hi Siva,

PFB script,

var gdt1 = new GlideDateTime("2011-08-28 09:00:00");
var gdt2 = new GlideDateTime("2012-09-01 10:00:00");
var dur = new GlideDuration();
 
var dur = GlideDateTime.subtract(gdt1, gdt2); //the difference between gdt1 and gdt2

gs.print(dur.getDisplayValue());
gs.print(dur.getDayPart());

var days = dur.getDayPart();
var weeks = parseInt(days/7);

gs.print(weeks);

Regards,
Bala T

View solution in original post

Ankur Bawiskar · ‎03-15-2022

Hi,

you can use before insert/update BR and store that

based on your requirement

regards
Ankur

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

Ankur Bawiskar · ‎03-14-2022

Hi,

something like this

var start = new GlideDateTime(start);
var end = new GlideDateTime(end);
var dur = new GlideDuration();

dur = GlideDateTime.subtract(start, end);
var weeks = dur.getNumericeValue()/604800000;

gs.print(weeks);

Regards
Ankur

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

Ankur Bawiskar · ‎08-11-2022

@siva

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

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