Relative filter operator on date field not showing "On", "On or After", "On or Before" in Orlando - Known Error

Relative filter operator on date field not showing "On", "On or After", "On or Before" in Orlando Description Date fields for list filter operator 'relative' is not showing all the options as they used to. Only "Before" and "After" options are visible. "On", "On or After", "On or Before" is not visible in Orlando.

This is working as expected and was removed on purpose as these options never worked as expected. The alternative to using these options is described in the workaround section.

These options were removed as a solution for PRB643537: Issue with the filter 'relative on X Days from now'

Steps to Reproduce

1) Login to an orlando instance 2) Go to any list view of a table (incident, change, problem) 3) In the filter, pick a date type field (Created) 4) For the operator select 'relative' 5) Notice that there are only two options available, "Before" and "After" 6) Reproduce the same steps in a NewYork instance and notice that all the options are present.

Workaround You can achieve the same results using alternate filter options:

For Relative On or before and Relative On or after, you can get the same results using the Relative before and Relative after options.

For example: Created [Relative On or before] 6 [days ago] is the same as Created [Relative before] 5 [days ago]

Created [Relative On or after] 6 [days ago] is the same as Created [Relative after] 7 [days ago]

For Relative On or before "from now" and Relative On or after "from now", you can get the same results using Relative before and Relative after options as below.

For example: Created [Relative On or before] 6 [days from now] is the same as Created [Relative before] 7 [days from now]

Created [Relative On or after] 6 [days from now] is the same as Created [Relative after] 5 [days from now]

For Relative On, the result can be achieved by using a combination of Relative before and Relative after. For example: Created [Relative On] 2 [days ago] is the same as Created [Relative before] 1 [days ago] and Created [Relative after] 3 [days ago]