Column Search does not work with correct date format - Known Error

Column Search does not work with correct date format Description Searches using the column search at the top of a list do not respect the date format currently in use (set either by system property or user preference). Instead, all dates are expected to be in the format YYYY-mm-dd. If you enter a date that is not in this format, no search results are returned.

For example, a record in the list shows a date of 15-03-1995 (15 March 1995). If you use the column search method to search for "15-03-1995", no result is returned. However, if you search for "1995-03-15", the record is displayed in the list. Steps to Reproduce

Using a Geneva instance with demo data installed, perform the following steps:

Impersonate an ITIL User.

Navigate to Self-Service > My Profile .

Select the date format dd-MM-yyyy.

Click Update .

In the application navigator, type sla.list and press the Enter key.

Click the gear icon to personalize the list and show the Begins column.

Only one record should appear in the list, and it should show a date in the Begins column of 11-07-2006.

Click the search icon to show the column search headers.

Type 11-07-2006 into the Begins column's search field and press the Enter key.

Type 2006-07-11 into the Begins column's search field and press the Enter key.

Expected behavior

For the search in Step 8 to return one search result because "11-07-2006" matches the date in the Begins column of 11-07-2006.

For the search in Step 9 to return no search results because "2006-07-11" does not match the 11-07-2009 date in the Begins column.

Actual behavior

Step 8 returns no search results because the search string is not in the format YYYY-mm-dd.

Step 9 returns one search result because the search string is in the format YYYY-mm-dd.

Workaround Use the list filter instead of the list column search. List filters respect the date format currently in use by the system.