Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you might find the site temporarily inaccessible. Thanks for your patience. Read more.
×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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.