nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Screenshot 2024-01-28 at 02.07.38.png

Screenshot 2024-01-28 at 02.06.17.png

Accepted answers

Bill Sheboy

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

All comments

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

Bill Sheboy

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}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-cloud