Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Date Field Filter Problem

Leigh Riffel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 5, 2018

JIRA v7.6.1

We have a custom date/time field called "Implementation Date" and we have a filter with the following definition:

"Implementation Date" is EMPTY OR "Implementation Date" < startofday() ORDER BY Updated DESC

Until the upgrade to 7.6.1 this was working fine, but now it includes results with Implementation Dates in the future.  I also tried with a hard coded date.  This variation does not work either:

("Implementation Date" is EMPTY OR "Implementation Date" < "2018-02-05") ORDER BY Updated DESC

Interestingly if I remove the part that includes EMPTY implementation dates, it correctly excludes future "Implementation Dates".

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events