Need help combining and converting string values (stored as HH:mm:ss) with date value (yyyy-mm-dd)

[Michael Catmur]

Need help combining and converting string values (stored as HH:mm:ss) with date value (yyyy-mm-dd)

• I have a custom field (issue.customfield_11248) which is storing a string for time (StartTime). 
• I have another custom field (issue.customfield_11124) which is storing the date (StartDate). 
• I have another two custom fields for EndTime and EndDate (issue.customfield_11250 and customfield_11125)
• The mask for entering data into the string field is HH:mm:ss

I need to calulate the days, hours, minutes and seconds between start date/time and end date/time, in a Jira Service Desk automation, and to poulate that value into another customfield for "duration"

As a first step I tried concatenating the time and date fields using:

{{issue.customfield_11124.concat("T").concat(issue.customfield_11248)}}

But this first step failed with:

"Unable to render smart values when executing this rule:

Too many numbers or variables: d h m s"

I'm not a developer, and stumpped how to progress... can anyone shed any light/insight?

[Bill Sheboy]

Hi @Michael Catmur -- Welcome to the Atlassian Community!

For a question like this, context is important for the community to help.  Please post the following:

• what version of Jira are you using: Cloud, Server, or Data Center
• for Cloud, what type of project is this: company-managed, team-managed, JPD, etc.
• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution
• explain what is not working as expected and why you believe that to be the case

Until we see those...

Are you using the built-in Start Date and End Date fields, or did you create additional custom fields with the same names?

What are the types of your fields: text, date, or date / time?

Kind regards,
Bill

[Kim Euker]

While this won't solve your issue, it will help with what you are trying to do.

Change your statement to:

{{#Debug}}{{issue.customfield_11124.concat("T").concat(issue.customfield_11248)}}{{/}}

Then post the output here.  If you get an error, post each piece separately so that we can see your data