smart value/JQL with date

[bartlomiej.jochym]

Hi, is it possible create smart value/JQL to write hours and minutes like example 2 hours 53 minutes instead of 2254?

Currently I have one created as in the picture, but it returns only minutes or hours (depending on the setting), but without the minutes note

[Bill Sheboy · Accepted solution]

Hi @bartlomiej.jochym 

Have you tried using the date / time difference with the prettyPrint format?  That should produce what you asked.  For example:

{{issue.created.diff(now).prettyPrint}}

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

Kind regards,
Bill

[bartlomiej.jochym]

thanks it works, I changed my query to {{triggerIssue.Begin Date.diff(now).prettyPrint}}

[Fabian Lim]

Hi @bartlomiej.jochym

You can probably create the variables to capture the hours and minutes separately and then put them into a string using math functions and string concatenation -> Link: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

I hope this makes sense.  

Fabian