date time format with automation for Jira

[Deleted user]

I would like to present the Jira user with an absolute time value that reports the difference between the creation date and the current date when an issue goes from to do to in progress.

I'm currently using this rule, but as you can see, the result is a date and time.

I would like to output the exact hours (hours and minutes) or a format like weeks, hours, minutes.

I can't find any information on how to format the dates in the result with automation for Jira.

Can you help me?

[Bill Sheboy]

Hi @[deleted] 

Please look at this documentation to learn for available formats for the date diff() function:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/

If none of those meet your needs, you will probably need to do this manually with the math operations and format() function:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/

Best regards,

Bill

[Sam Harding]

This is the correct answer, a smart value using diff and format will do the trick:

{{now.diff(issue.created).format("toHours")}}