Computation of Weeks in 2 different Date and Display it to Duration Date Field.

[Jeck Manalo]

Hi,

How can I display the weeks on "Duration Date" (u_duration_date)

Created it using BR when to run before insert/update

var start = new GlideDateTime(u_start_date);

var end = new GlideDateTime(u_end_date);

var dur = new GlideDuration();

dur = GlideDateTime.subtract(start, end);

gs.print(dur.getDisplayValue());

gs.print(dur.getDayPart());

var days = dur.getDayPart();

var weeks = parseInt(days/7);

g_form.setValue(u_duration_date, gs.print(weeks));

[ahefaz1 · Accepted solution]

var start = new GlideDateTime(current.getValue('u_start_date'));
var end = new GlideDateTime(current.getValue('u_end_date'));
var dur = new GlideDuration();

dur = GlideDateTime.subtract(start, end);
var days = dur.getDayPart();
var weeks = parseInt(days/7);

current.setValue('u_duration_date' , weeks);

@Jeck Manalo ,

You cannot use g_form in a business rule.

I think you need to add this to your BR

current.setValue("u_duration_date" , weeks);

Thanks,

[Jeck Manalo]

not working

[ahefaz1]

@Jeck Manalo ,

just updated it again. Please try.

Thanks,

[Jeck Manalo]

same result 😞