Automation failing because jql can't read input date

[Katie Sobolik]

I am trying to run this automation, which should be triggered manually, then prompt for a startDate. That start date should be input into this jql filter query: 

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created >= {{startDate}} 

This is the failure I get from the audit log: 

Manual trigger from issue 02/19/2025, 09:32:28

Create variable 02/19/2025, 09:32:28

JQL condition 02/19/2025, 09:32:28 JQL didn't run, which prevented the JQL condition from passing and its actions from being executed: Invalid JQL: project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created >=

I know the issue is around the startDate, but I can't figure out how to fix it. This is the variable: Variable name = startDate    Smart value={{userInputs.startDate}}

Any help would be appreciated

[Vishal Biyani · Accepted solution]

@Katie Sobolik 

Assuming your variable name is: startDate and your input date is 02/19/2025 09:32:28 and you need to use time part, then below will work. / is a reserved keyword for JQL and your date format is giving errors. JQL does not take seconds so that needs to be removed.

if your format was in yyyy-mm-dd format, then it would have worked as it.

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created > {{userInputs.startDate.toDate("MM/dd/yyyy H:m:s").format("yyyy-mm-dd H:m")}}

Apologies for the multiple edits as the time part had to be incorporated as well.

[Katie Sobolik]

made the updates and still receiving the same error. also updated the startDate

[Vishal Biyani]

project = "Data Management" and summary ~ "dbt Job Run: Test_Center.Test" and issuetype = "Test Execution" and created > {{userInputs.startDate.toDate("MM/dd/yyyy H:m:s").format("yyyy-mm-dd H:m")}}

Check with this date  02/19/2025 09:32:28 

[John Funk]

Hi Katie - Welcome to the Atlassian Community!

Try this: {{userInputs.startDate.jiraDate}}