Dates search in Drupal (greater than, less than) using CCK / views / facelet?

Posted by guillefar on Stack Overflow See other posts from Stack Overflow or by guillefar
Published on 2010-06-11T13:29:12Z Indexed on 2010/06/11 13:32 UTC
Read the original article Hit count: 179

Filed under:

search

|

drupal

|

dates

I'm working in a site that manage events (like parties). Each event could have several fields, including date, that the user could add thanks to CCK module.
Now, the problem is when I have to search using those fields.
I could not find how to search for events between a range of dates.
I discover the facelet module, which is pretty good, and it is very useful for some kind of search, but as far as I can see it is not possible search in a range.
Also I do some testing using views, but again, with no results. I can not find how to search a date "greater than" and "less than".
I will really appreciate any help.

© Stack Overflow or respective owner

Related posts about search

"Error in the Site Data Web Service." when performing crawl

as seen on Server Fault - Search for 'Server Fault'
Installed SharePoint Services v3 (SP2, october 2009 cumulative updates, Language Pack), attached to a content database I had previously (all works). Installed Search server 2008 Express (with language pack) on top of WSS and crawl does not work. However it works for newly created web application +… >>> More
Search Alternative Search Engines from within Bing’s Search Page

as seen on How to geek - Search for 'How to geek'
So you love using Bing Search but may still be curious to see what another search engine will provide if used. Now you can search using another search engine from within the Bing Search page and enjoy numbered results using two simple user scripts. Note: These user scripts may also be added to other… >>> More
CONVERT(int, (datepart(month, @search)), (datepart(day, @search)), DateAdd(year, Years.Year - (datepart(year, @search)))

as seen on Stack Overflow - Search for 'Stack Overflow'
In the query the top part is getting all the years that will run in the stored procedure. Works fine But at first i just wanted to run the queries for yesterdays date for all the years, but now i realized i want the user to select a date that will be in a parameter @search Booked <= CONVERT(int… >>> More
Am?lioration du Search MOSS: synonyme et Best Bet - La gestion des synonymes dans MOSS Search

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Le moteur de recherche de MOSS permet la configuration d'une liste de synonymes. Nous verrons donc dans cet article comment effectuer cette tache et ce que cela peut apporter ? vos utilisateurs. Nous verrons aussi comment automatiser un peu plus cette configuration par l'utilisation de code ou d'outils… >>> More
Utiliser un MOSS 2007 Search avec SPS 2003 - Comment utiliser un MOSS Search avec SPS Portail

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Microsoft Office SharePoint Server 2007 (MOSS) fournit de nombreuses fonctionnalit?s qui ne sont pas disponibles sous SharePoint Portal Server 2003 (SPS). C'est particuli?rement vrai pour le moteur de recherche. Ce moteur de recherche peut pourtant ?tre utilis? sans attendre une ?volution du site… >>> More

Related posts about drupal

Commercial Drupal Modules & Themes

as seen on Just Skins - Search for 'Just Skins'
A discussion at Drupal.org forums prompted me to give my input about commercial ecosystem around Open Source Content Management Systems. WordPress and Joomla have been growing rapidly since past few years. But, growth rate of Drupal seems to be almost flat. Despite being the most powerful CMS around… >>> More
better to wait Drupal 7 to start learning Drupal, or no big difference with Drupal 6?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I'm going to start some projects in next weeks. I currently have my custom cms, but i wanna go for opensource cms solution from now on. and as i researched Drupal is COOL for any kind of project from small scope to most complex ones. I have never used Drupal before, I know nothing about… >>> More
Drupal 6: Drupal Themer gives same candidate name for different type of content types

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I'm a drupal newbie... I have different type of contents like News, Events, etc. and their content is different. News detail page has title-content text-date. but Events detail page has title-date-content text-location-speaker-etc. So I need different layout page for these different… >>> More
drupal: how to generate doc files in drupal is there any possibility to that

as seen on Stack Overflow - Search for 'Stack Overflow'
how to generate doc file in drupal files.. do we have module for that... as pdf generation module... >>> More
Drupal 6 vs Drupal 7 performance

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all. I want to start new project and stuck without idea what version to use. I have huge expirience with D6, and also one project (module developement) for D7. It looks like D7 slower, have bigger memory consumption and also have a lack of documentation by the moment. I don't need new CCK, Views… >>> More