what is wrong in below script?

[Sathwik1]

What is wrong in below script?

var schedule = new GlideSchedule(inputs.schedule_sys_id);

var start = new GlideDateTime(inputs.starting_date);

var end = new GlideDateTime(inputs.ending_date);

var duration = schedule.duration(start, end);

outputs.duration = duration;

Here duration value is fine, perfectly caluclating.. but in backend table it is not setting up.. ending up as "return type is not valid"

In the above..my ouput field type is duration... in bacend table as well.. field type is duration.

@Tanushree Maiti @Ankur Bawiskar 

[marianbruma]

Hi @Sathwik1 

schedule.duration() returns a GlideDuration object. Could you confirm where this script is running (Flow Designer Action, Script Include, Business Rule, etc.)?

Also, when you say the backend field is a Duration field, are you writing outputs.duration directly to that field, or is there another step that performs the update?

The error "return type is not valid" suggests the value being returned isn't in the format the consumer expects, rather than an issue with the duration calculation itself.

Hope it helps,

[Vikram Reddy]

schedule.duration() returns a GlideDuration object, which Flow Designer cannot store directly.

Return a string instead:

var duration = schedule.duration(start, end);
outputs.duration = duration.getValue();

Configure the output as String. If you only need a readable value, use:

outputs.duration = duration.getDurationValue();

Thank you,

Vikram Karety,

Octigo Solutions INC 

[Ankur Bawiskar · Accepted solution]

@Sathwik1 

try this

var schedule = new GlideSchedule(inputs.schedule_sys_id);
var start = new GlideDateTime(inputs.starting_date);
var end = new GlideDateTime(inputs.ending_date);

var dur = schedule.duration(start, end);
outputs.duration = new GlideDuration(dur);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Sathwik1]

Still same error "Invalid return type encountered" @Ankur Bawiskar