Using date variables with Jira automation smart filters is not working

Adrianna Bell

@Trudy P Claspill I read this dialog Solved: Jira automation to set Target End using smart valu... and tried to apply the same logic to mine automation but it isn't working.

• I created a variable of: NewDate: {{now.endOfMonth.shortDate}} which produced the correct value.
• I then created a variable of: BusDay: {{#NewDate.toDate}}func=plusBusinessDays({{DayNum}}) {{/}} which resulted in blank output.
• I put a log in before the variable was created and it shows NewDate=9/30/25 and DayNum=13 which is correct.

Any ideas why this isn't working?? I'm about to pull my hair out as I've tried soooo many variations trying to get this to work.

David Freitez

Hi @Adrianna Bell 

I checked the implementation you suggested and hit the same problem but after testing several times, I saw that the problem was the shortDate format you are requesting to function,  if you eliminate that part, the function would return a date which is field type used for the Date operation.

 

So, to summaryze, use: 

NewDate: {{now.endOfMonth}}   instead of   NewDate: {{now.endOfMonth.shortDate}} 

The function you are using worked correctly for me.

Kindly give it a try and let me know if you need further help.

Also, if you consider my comment help you solve the issue, please mind to mark it as the Answer.

Kind regards,
David