Date comparison issue

Question

When I run the query, "User" = abc and "Program Epic Due Date" <= now(), I get few issues. 1 of the result, APC-15 ,is incorrect as its Program Epic due date is 28/Feb/20.

When I run the following query, "User" = abc and "Program Epic Due Date" <= -1d, where I replace now with -1d, I do not get APC-15 which is the right record.

This does not happen with the usual JIRA Date fields. The Program Epic Due Date is a scripted field.

Can someone please help me with the reason for this, and how to fix it.

Thank you

Aisha M · Answer

@Payne  Hi Payne. Thank you for the comment. The scripted field template is a DATE TIME RANGE picker.

Payne · Answer

Your field may have the incorrect Search Template chosen. Go into custom fields (type gg or . and then type custom fields), type your field name, click the cog and choose edit, and set the Search Template to Date Time Range picker. May need to perform a reindex after doing this.

-Payne

Olga Videc · Answer

Hello @Aisha M

Okay found it, so simple you need to use duedate < now()

now() does not support <=     it supports <=WAS* but not <=

Also make shure your custom field is Date/Time template

BR, Olga