Scheduled automation of a JQL is failing

Question

Hello,

I'm trying to create an automation that will check the number of weeks between 2 date fields.

It is a scheduled automation with a JQL (For the testing I'm looking for specific test tickets)

Then I'm trying to check the amount of time between my 2 custom fields with: 
{{issue.customfield_10751.diff(issue.customfield_10750).days.divide(7)}}

And according to the number of weeks, I want to set a certain field.

The automation is failing.

When trying to debug and print in a log the values of {{issue.customfield_10750}} for example, it returns nothing, an empty log.

Will appreciate the help, Thanks!

arielei · Accepted Answer

Hey @Ofir Oxenberg

try adding "jiraDate()" like this:

either way, check the {} smart values for your options on how to get the value of the date.

Bill Sheboy · Accepted Answer

Hi @Ofir Oxenberg

If you write both of those date fields to the log before the condition, what do you observe in the values?

Have you tried using the weeks unit of measure for the diff() rather than using days and dividing by 7:

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

And, some other things about your expression:

* The result of the diff() function is an integer, and so when you divide that value, integer division is used.  Thus the round is not needed, and the results could be different than you expect.  (The exception is when prettyPrint format is used.)
* The inline version of the round function does not take parameters, and so that may be causing problems.  As noted above, the function is not needed if you just use weeks for the units.

Kind regards,
Bill

Ofir Oxenberg · Accepted Answer

Back again,

Now, when I change the query to 
{{issue.customfield_10751.diff(issue.customfield_10750).weeks}}

I get a round number, and I'm trying to get the decimal number. 
For example, if the number of days between 2 dates is 34, then the gap is 4.8 weeks, and i get 4 from the query.

What do i need to change to get the decimal number?

Thanks!