How to search for dates and/or a date range

You've got questions? We think we have some answers!

Moderator: Mods

How to search for dates and/or a date range

Postby Greg Dawes » Thu May 03, 2007 4:03 pm

There was a change to the logic in the formation of date searching beginning with v5.6 (build 3377). Therefore, this post applies to X1 Enterprise Client versions 5.6.x

Specific Date
To search for a specific date (for example July 2, 2006), you could enter any of the following:


In the above examples, dashes '-' and slashes '/' are interchangeable (for example, you could enter: jul/2/06). You can also enter the full year, 2006, in place of 06 (for example, you could enter: jul-2-2006)

Date Range
However, for date range searching, the dates *must* be in the format: yyyy-mm-dd. As an example, to search for dates from July 20, 2006 to July 29, 2006, enter:

BETWEEN 2006-07-20 AND 2006-07-29

In these examples, dashes '-' and slashes '/' are interchangeable.

Date Range - Specific Month
To search for a specific month and year (for example July 2006) you could use any of the following:


Again, dashes '-' and slashes '/' are interchangeable with the above examples and the year must be in the format, yyyy

There is also a Knowledge Base article which describes this behavior.
Greg Dawes
QA Engineer
X1 Technologies
Greg Dawes
X1 Rep
X1 Rep
Posts: 638
Joined: Thu Jul 07, 2005 9:46 am
Location: Pasadena, CA

Postby Kenward » Fri May 04, 2007 1:01 am

Here is a link to the KnowledgeBase article:

[url=]How do I perform date range searches?

Unfortunately, the design of the KnowledgeBase means that you get kicked out into a frame. There doesn't seem to be a convenient way to bookmark those articles.
X1 Search 8.6.1 - Build 6003fa (64-bit)
Windows 10 Pro 64-bit | Windows 10 Home 32-bit
No, I have nothing to do with X1, just a user since 2004.
X1 Guru
X1 Guru
Posts: 4149
Joined: Tue Apr 20, 2004 2:35 am
Location: UK

Return to Questions and Answers

Who is online

Users browsing this forum: No registered users and 41 guests