My Oracle Support Banner

Can Content That Matches the "To Date" in UCM Searches Be Returned in the Search Results? (Doc ID 1311575.1)

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.


The standard search page in Universal Content Management (UCM) allows you to search on dates, with a From Date field and a To Date field.

The search query is sent as follows:

From Date <= searched_date < To Date

This means that if you search with these dates, for example:
From Date: 2011-03-21
To Date: 2011-03-22

You will find all content with the Date of 2011-03-21, but no content with the Date of 2011-03-22.

Is there a way to include the To Date in the query, so content that matches the To Date will also be returned in the search results?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.