calculate the weeks between the dates

[siva58]

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 · Accepted solution]

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

[siva58]

1.here two times "dur"  declared, it showing as error

var dur = new GlideDuration();
 
var dur = GlideDateTime.subtract(gdt1, gdt2); 

2, how to populate  that result in another field..

[Ankur Bawiskar]

Check the script I shared; it should work fine

[siva58]

how to populate the result in another field;