dateCompare function not working when comparing date field to calendar date

mark zermeno March 18, 2024


I am trying to write a Filter that compares the Actual Trend Date field value in JIRA to a future date in time i.e '2024-03-11'. I've tried several ways to write this filter but get various errors like the one below.

Is it possible to compare a Date Field in Jira to an actual future calendar date?



2 answers

1 accepted

1 vote
Answer accepted
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2024

Hello @mark zermeno  I checked and I get the same behavior as you.

Looks like date compare does not take a "date" as argument for comparision but a field which is of date type.

May have to check this normally without the add-on function:

project = ABCD and 'Planned Completion Date' >= 2024-03-11


mark zermeno March 18, 2024

You're right, sometimes an easier solution works and this worked :). Thanks Kalyan.

Like Kalyan Sattaluri likes this
0 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

Hi @mark zermeno and welcome to the Community!

I believe you may be having issues with quotes in the last part of your statement. I think it should look somewhat like this:

issueFunction in dateCompare("","'Planned Completion Date' >= '2024-03-11'")

I don't have a test environment to validate, but hope this helps!

mark zermeno March 18, 2024

Thanks for the help Walter!  I tried this but still get a function error. Actual Trend Date is a date field in our JIRA so not sure why im getting this error.



Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events