By zoo on

Say below is a view with a bunch of nodes chronologically sorted by the "PERFORMED ON" cck date field:

    LESSON TITLE: ...
    PERFORMED ON: 2010/01/14 [<-- these are CCK DATE FIELDS]
    REPORT: ...

    LESSON TITLE: ...
    PERFORMED ON: 2009/01/28
    REPORT: ...

Well, I need visitors to be able to filter those lessons by: "year" OR "month" OR "day" (OR a combinations of) only.

An example: if a visitor selects from the exposed filter of the view, the day "14", I want only lessons performed on day "14" of any months of any years, to be showed.

How could I do?

zoo

⋅ Categories: Drupal 6.x

Comments

zoo’s picture

zoo commented

...hello, any clues? thank you,

zoo

zoo’s picture

zoo commented

Maybe it involves advanced skills? Maybe it is not possible?
Found nothing yet...

zoo

zoo’s picture

zoo commented

An example: if a visitor selects from the exposed filter of the view, the day "14", I want only lessons performed on day "14" of any months of any years, to be showed.

How could I do?

zoo

zoo’s picture

zoo commented

Sorry to bother, but I'll appreciate even if just a hint... thanks

zoo

amaisano’s picture

amaisano commented

I had similar needs for users to be able to search by day of week. For instance, "I only want to search for baseball games that occur on Thursdays."

I had trouble locating a perfect solution, but using the following tips I was able to create a drop down filter containing options for each day of the week.

http://drupal.org/project/computed_field

http://drupal.org/node/620262

Unfortunately I still haven't cracked how to convert this drop down down list into multi-select checkboxes.

Good luck!

amaisano’s picture

amaisano commented

To add to that, here is how I stripped the day of the week info from the date field for my computed value. You should be able to do similar for the month:

Computed Code

//$tmz = $node->field_game_date[0]['timezone'] - 86400; // Depending on your site's time-zone settings, you may need to shift this offset value manually
$tmz = $node->field_game_date[0]['timezone'] - 36000;
$dow = strtotime($node->field_game_date[0]['value']);

$node_field[0]['value'] = format_date($dow, 'custom', 'l', $tmz);
simone960’s picture

simone960 commented

I need to this date filter in Drupal 7 as well. If I expose them to year, week, day, the user has no choice but to choose one for each else nothing will come out excepting asking user to choose the other two. Any better module or way can do better in D7 ?