Date of BIrth and Age Searchability
-
Hi.
First, great plugin. For my needs it is 95% what I needed to replace an old Filemaker Pro Talent Database. The only thing missing is the ability to handle Birthdate or age searches.In the old system, we collected Date of Birth rather than asking a person’s age. Then we used a calculation field to calculate the person’s age so that it would always be correct as time went on. We were also able to search for a date range or age range in order to cast specific roles.
With PD, the first thing I’m a bit confused about is the way our Date of Birth is stored. In my CSV, all DoB’s were formatted like this: 01/02/2001, but it displays in both the backend and the various shortcodes as January 2, 2001. Browsing the database I see Unix Timestamps.
So far, every attempt I’ve made to filter or search the date_of_birth field has failed. I have strict date format disabled in settings. I followed these instructions from your site: Date values should be a regular date string like this: [pdb_list filter=’date>jan1,2000′] but it shows me everything. And I’ve tried numerous searches in the front end search form, but they all result in no records found. Even tried just searching for “March” with strict search off and nothing.
My first question, then, is to determine if it is possible to set up a calculation field: and Age field that will calculate the age based on the date_of_birth field. Then, this would be searchable or filterable for specific ages or age ranges.
AND/OR how do I search or filter a date field? I also tried filter=”date_of_birth>01/01/2000′ which also shows everything. I also tried filtering using unix timestamps with the same result. Ideally I’d like to be able to do a front end search of a date range. But I’d also be ok with being able to create multiple pages, each with a list that was filtered for a different age range which can be accessed via a menu I would create.
Is any of this possible to accomplish?
Thanks.
- The topic ‘Date of BIrth and Age Searchability’ is closed to new replies.