Date comparison issue

[Aisha M]

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

[Payne]

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

[Aisha M]

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

[Olga Videc]

Hello @Aisha M 

"Program Epic Due Date"  <= endOfDay()

BR, Olga

[Aisha M]

Hi @Olga Videc , Can you please help me with the reason for the above problem. Thank you

[Olga Videc]

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