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

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.

[April Alletha Lopez]

Thanks! That helped :)

What I did:

def DateTime1 = getCustomFieldValue("<name>") as Date --> for all dates

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

[Elifcan Cakmak]

Hi, you're welcome :)