Gossamer Forum
Home : Products : DBMan : Installation :

Date range searching

Quote Reply
Date range searching
An interesting problem has popped up. I have dbman set up as a contact database. When people try to search for a birthday before 1970, the search fails- even though there are records that match that criteria.
I've set up a demo at the following URL-
http://www.arvlfc.org/test/db.cgi?uid=default
it has two records, one with a birthdate of 1962, one with a birthdate of 1971. Try searching for <1-Jan-1969 and then <1-Jan-1972
Quote Reply
Re: Date range searching In reply to
It's a problem with the way Unix (and probably all computers) deal with dates. They count the beginning of time from 1-Jan-1970. Even 31-Dec-1969 doesn't work.

As a workaround, you might try having three fields for your birthdate -- day, month and year.



------------------
JPD