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 1:01 am

Here is a link to the KnowledgeBase article:

[url=http://na1.salesforce.com/_ui/selfservice/pkb/PublicKnowledgeSolution/d?orgId=00D300000000JpR&id=5013000000042y1&retURL=%2Fsol%2Fpublic%2Fsolutionbrowser.jsp%3Fsearch%3Ddate%2Bsearch%26cid%3D000000000000000%26orgId%3D00D300000000JpR%26t%3D4&ps=1]How do I perform date range searches?
[/url]

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.
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: 4076
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 28 guests

cron