By icouto on

I have a D6 installation, with the Profile module active, and the Views 2 module installed.

I have defined a "Date of Birth" field for my users - of type 'date' - using the Profile module. I thought it would be trivial to setup a block, using Views, that could display a list of users whose birthdays falls within this month. However, after much hair-pulling, I can't work it out whether it's possible to do it at all.

Although I can see the 'Date of Birth' field in the "Fields" list inside my View spec, when I click on '+' under "Filters" - to try and add a filter based on the DOB - the 'Date of Birth' field is *not listed*. If I try to use "Arguments" instead of filters, the same thing happens - ie., the DOB field is not even listed.

Surely, I'm certain that others must have come across this problem before, and that there *must* be an easy way to solve it. If we cannot filter users by a date field, how can we keep track of membership expiry dates, renewal dates, anniversaries, etc.?

Any help would be greatly appreciated!

⋅ Categories: Drupal 6.x

Comments

WorldFallz’s picture

WorldFallz commented

I'm not sure why profile date fields don't show up in the arguments and filters options-- but user created date and last login date do show up and are configurable so you can check for access and expirations. Maybe it's a bug... did you search the views issue queue?

===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz

silid’s picture

silid commented

I believe this is meant to enable this:
http://drupal.org/project/date

WorldFallz’s picture

WorldFallz commented

I just added that module and tested-- it's still a problem. And it also seems not to be limited to profile date fields-- cck date fields are not appearing in the filters/arguments list (but do appear in the fields list).

EDIT: cck date fields are used in filters/arguments a little differently-- first you pick a generic "date" type, then all the date fields appear in a radio checklist to select which date field you want to filter on. This is not available with Profile views-- that i can find anyway.

===
"Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime." -- Lao Tzu
"God helps those who help themselves." -- Benjamin Franklin
"Search is your best friend." -- Worldfallz

icouto’s picture

icouto commented

After searching through the Views issue queue, I could not find anything related to "date field" or "profile date", so I've added a new issue here:

http://drupal.org/node/311514