Calculate

I have two custom field that show data with format (week, day, minutes,second),

I want to found difference two custom field,

example:

custom field 1 : 4w,2d,3m

custom field 2: 2w,3d,45m,8s

How do found difference between two custom field?

tanks

1 answer

0 votes

It seems like these 2 customfields are free text, am i right?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

yes, when create issue the custom field is free text.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Then you must (programmatically) parse each text field into objects and convert each one to actual time values.

Once each field converted you will be able to do simple cf1-cf2 (minus) and you will get the diff

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

I know.
My problem is with formatting

How do Uniformize two custom field?

I work with calculated date- time field (by JWT).

thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.