Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Column Search does not work with correct date format - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • Column Search does not work with correct date format
KB0565054

Column Search does not work with correct date format


1458 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

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:

  1. Impersonate an ITIL User.

  2. Navigate to Self-Service > My Profile.

  3. Select the date format dd-MM-yyyy.

  4. Click Update.

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

  6. 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.

  7. Click the search icon  to show the column search headers.

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

  9. 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.


Related Problem: PRB622619

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.