Date format is Fulltext search a mystery

Fulltext searching in Domino is often a great way to find documents. Searching for information in documents is quite straight forward. Until you want to search for dates in web applications. If you have an web application in XPages and want to search for documents created after a certain date. You can write a query like this

[_CreationDate]>2001-05-01

But what if you users has an english locale with a date format like this mm/dd/yy and the user enters the date from a date field in an xpage.

Is it the user locale / server locale or what is the date format you should use?

============= UPDATE ================

I got an private email from a guy called Timothy Briley saying that the way to move forward when creating multi locale fulltext searches is to always get the retult from the DateOnly property on the NotesDateTime object. I haven’t tried it yet but it sounds reasonable 🙂

 

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>