Hi All,
Is there any way to display document which is created between two dates using “?searchView&query=…” url options. I need to display the document which is created between any two dates. User will input the from and to date and when click go it will collected all the document.
Please Help.
I will be very thankful to you.
With Regards,
Vikas
Subject: RE: Search view
Is this a Domino web application? If so, certainly you can do this query by calculating the URL and using the query syntax, which is documented in the client help, URL encoded of course. The query would be:([datefield] >= 4/4/2008) and ([datefield] <= 6/8/2008)
for instance
Subject: RE: Search view
Thanks Andre for your quick response.This is complete web-based application and the document what I am searching it is also created from web. There is PostedDate Field on the form from which document is created.
what I wrote
http://www.abcauto.in/company.nsf/postjob?searchview&query=([postedDate]>=05/12/2008)
when i hit this url it shows me on server console
Relational Operator are not supported in text fields.
and on browser
“HTTP 500 - Internal server error”
Where as I have created PostedDate as Date/Time Field.
Could you explore more where i am doing wrong. Please help me.
With Regards,
Vikas K Sinha
Subject: RE: Search view
This is one of the reasons you must never, never store date values in a text field. Date values must be stored in date format, or all sorts of things won’t work.
This has been addressed in this forum many times. You will have to:
change the field to a date/time field instead of text.
find any code that is assigning a value to the field, including input translation formulas, and make sure they are assigning a date/time value rather than text.
Write an agent to fix all your existing documents by converting the field value to a date/time and resaving the document.
Once all your documents are fixed, delete and re-create the full-text index, because it currently has it stuck in its head that this is a text field.