dateCompare function not working when comparing date field to calendar date

[mark zermeno]

Hello,

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?

[Kalyan Sattaluri · Accepted solution]

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]

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

[Walter Buggenhout]

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]

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.