Scripted field calculate from two date fields

April Alletha Lopez

Hi,

I need to create a scripted datetime field based on difference in duration between two datetime fields.

Formula:

DateTime3 = DateTime1 + (25% of duration from DateTime1 to DateTime2)

Legend:

DateTime1 => input Field, Date Time Picker
DateTime2 => Scripted Field based on DateTime1, Date Time Picker
DateTime3 => Scripted Field, Date Time Picker

This is not working:

def period = (DateTime2.getTime() - DateTime1.getTime()) * 0.25;
return new java.sql.Timestamp(DateTime1.getTime() + period);

Any suggestions?

Thanks.

Elifcan Cakmak

Hello

What error do you get?

Can you try converting period to integer like this:

return new java.sql.Timestamp(DateTime1.getTime() +period.toInteger());

When I try your code with this, it seems to work.