Set a Follow Up Due Date based on the current date plus a number from a custom field.

[Todd Skelton]

I'm trying to set a future follow up date based on the value in a numeric custom field added to the current date

Currently, I have my Edit field automation step set as follows in order to set a custom field called Follow Up Date: {{now().plus(issue.customfield_10402)}}

But this always returns "None". 

Any ideas what I'm missing?

.   

[Bill Sheboy · Accepted solution]

Hi @Todd Skelton 

The current date / time function is {{now}} and not {{now()}} and your date increment is missing the units of measure, such as plusDays() 

Please look here for examples of the syntax to increment a date / time value: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-plus-unit---

Kind regards,
Bill

[Todd Skelton]

Thanks.   I can get that to work if I just hard code a number of days in the JQL, but If I want the number of days to come from a custom numeric field it doesn't update my Follow Up Date field.

{{now.plusBusinessDays(issue.customfield_10402)}}  leads to no update.

{{now)).plusBusinessDays(issue.customfield_10402)}} just updates to today's date. 

[Todd Skelton]

[Bill Sheboy]

What is the type of your field, customfield_10402?

If it is text, please add asNumber to convert it inside of the function call:

{{now.plusBusinessDays(issue.customfield_10402.asNumber)}}

If it is something else, please post an image of the audit log details showing the rule execution.  That my provide more context for what is happening.

[Todd Skelton]

Hi Bill, it is a number field.  The audit log says it's editing the value successfully, but it doesn't.  I also tried it as a text field.   As a text field the number got rendered as 2.0.

Thanks again

[Bill Sheboy]

Please try writing that custom field to the audit log to confirm it contains what you expected when the rule runs:

Field contains: {{issue.customfield_10402}}

 And what type of field is the custom field "Follow Up Date": a date picker or something else?

[Todd Skelton]

Thanks.   Follow Up Date is a date picker.   Here's the actions logged for both the Days Until Next Follow Up and Follow Up Date fields.   

Days Until Next Follow up is showing as 5.0 and the rule isn't successfully setting the date field based on the current date plus the days

[Bill Sheboy]

This is quite curious...

Have you confirmed that the field "Days Until Next Follow up" is in fact customfield_10402?

Have you tried using the user input directly to see if you get the same result?  Perhaps try writing this to the audit log:

now plus user input: {{now.plusBusinessDays(userInputs.followupdays.asNumber)}}

[Todd Skelton]

Thanks Bill.   The issue was indeed that I had transposed the custom field number.  Fixed that and it's working as I wanted it to!

Thanks a bunch for your help!