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

[JMWE] Automation to fill day count

RIZKY JTUASIKAL

I have a custom field :

"Latest Plan Live." (date field)

I am implementing automation to fill in my "Days to fill" field with the number of days.

For example:

Latest Plan Live = March 1

Current Date (calendar date) = March 30

Days to fill should show 30 (?)

I have this formula, but got an error message:

How do I need to update this formula to produce the correct count of calendar days?

Accepted answers

David Fischer

Hi @RIZKY JTUASIKAL

Try this:

{{ now | date('diff', issue.fields["Latest Plan Live"], 'days') + 1 }}

See https://appfire.atlassian.net/wiki/spaces/JMWEC/pages/466323491/date+filter#diff for details

All comments

David Fischer

Hi @RIZKY JTUASIKAL

Try this:

{{ now | date('diff', issue.fields["Latest Plan Live"], 'days') + 1 }}

See https://appfire.atlassian.net/wiki/spaces/JMWEC/pages/466323491/date+filter#diff for details

RIZKY JTUASIKAL

Hii @David Fischer ,

Thanks in advance for answering my question..

But I want to ask again,
when I did the first test with the following dates:

Current day = September 25, 2024
Latest Plan Live = September 20, 2024

I get the result 6.

Then I did the 2nd test, where the data is as follows:

Current day = September 25, 2024
Latest Plan Live = September 30, 2024

I get the result -3.

But shouldn't the result be -6?

CMIIW

Once again, thank you very much for your help @David Fischer

RIZKY JTUASIKAL

Hi @David Fischer ,

I found an alternative query, and maybe we can use it.

with the following dates:

Current day = September 25, 2024
Latest Plan Live = September 30, 2024

But I would still like to know the answer to the question I asked earlier

David Fischer

Hi @RIZKY JTUASIKAL

You should actually remove the "+1" from my previous snippet.

As for using businessDiff, it's different since it only counts business days, but sure, you can use it instead of "diff" in my previous snippet.

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

addon-com.innovalog.jmwe.jira-misc-workflow-extensions

automation

date

jira-automation

jmwe