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:

jul-2-06
july-2-06
2-jul-06
2-july-06
06-2-jul
06-2-july

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:

2006-07-20..2006-07-29
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:

july-2006
jul-2006
2006-july
2006-jul

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
http://www.x1.com/company/contact-us
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 12:51 am

Aha! So X1 has seen the light and rejected a dumb dating system.

This gets you the KnowledgeBase article:

How do I perform date range searches?

Unfortunately, the design of the KB is such that I can't find a link that does not throw you out of the system into a frame. Maybe that is why Greg didn't post a link.
MK
X1 Search 8.5.2 - Build 6001si (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.
Kenward
X1 Guru
X1 Guru
 
Posts: 4107
Joined: Tue Apr 20, 2004 2:35 am
Location: UK

Re: How to search for dates and/or a date range

Postby thoma » Mon Feb 13, 2012 4:56 pm

do you know what the search criteria would be for a search by certain time?

e.g. all emails sent after 5 pm

< 5:00 pm results that match '00' and 'pm'

> 5:00 pm doesn't produce any results.

thanks for any input
thoma
 
Posts: 2
Joined: Mon Feb 13, 2012 4:51 pm


Return to Questions and Answers

Who is online

Users browsing this forum: No registered users and 35 guests

cron