Gossamer Forum: Products: DBMan: Customization: Searching the date field

Jul 26, 2000, 11:44 AM

omegadm

User (130 posts)

Jul 26, 2000, 11:44 AM

Post #1 of 5

Shortcut

Searching the date field

Is it possible to search a date field??

I have the date stored as 26-Jul-2000 (added automatically when a new record is created) and would like to use this for searching e.g. Search all additions in Jul.

However, typing just 'Jul' in the form field gives: invalid format. If I type the exact date '26-Jul-2000' it works (case sensitive as well).

Best regards, Brian

Jul 26, 2000, 1:30 PM

Leprechaun

Novice (41 posts)

Jul 26, 2000, 1:30 PM

Post #2 of 5

Shortcut

Re: Searching the date field In reply to

You could do a search of GREATER than 01-Jul-00, or LESS than 28-Jul-00, but I'm not aware of doing one in between the two. I've always just searched one or the other and then SORT BY DATE to get all of those dates together.
Hope that helps a little bit.

Conor Treacy
-----
www.HandsonWebDesign.com

Jul 26, 2000, 3:07 PM

JPDeni

Veteran / Moderator (8669 posts)

Jul 26, 2000, 3:07 PM

Post #3 of 5

Shortcut

Re: Searching the date field In reply to

You can make a change that will allow a search like you want.

In db.cgi, sub query, look for

Code:

if ($in{$column} !~ /^\s*$/) { ($db_sort{$column} eq 'date') and (&date_to_unix($in{$column}) or return "Invalid date format: '$in{$column}'");
push(@search_fields, $i); $i++; next; }

There are five lines that look similar. You want to work with the third one.

Change the above to

Code:

if ($in{$column} !~ /^\s*$/) {
push(@search_fields, $i); $i++; next; }

This will allow you to search for just part of a date.

JPD
http://www.jpdeni.com/dbman/

Jul 26, 2000, 5:02 PM

omegadm

User (130 posts)

Jul 26, 2000, 5:02 PM

Post #4 of 5

Shortcut

Re: Searching the date field In reply to