Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Installation :

Searching on Dates

Jan 19, 1999, 5:58 AM
Jaime Ortega
User (119 posts)
Jan 19, 1999, 5:58 AM
Post #1 of 5
Views: 2414
Shortcut
Quote Reply
Searching on Dates
Is there any way I can search on monthly bases i.e. All records added in January, February, etc...

Is there something I can put in the search condition of dates to look for patterns (like Jan, Feb,...). It seems that I can only do greater than or less than searches (&Reg_Date=%3E... or &Reg_Date=%3C...)

Thanks
-JO
Jan 19, 1999, 7:40 AM
JPDeni
Veteran / Moderator (8669 posts)
Jan 19, 1999, 7:40 AM
Post #2 of 5
Views: 2319
Shortcut
Quote Reply
Re: Searching on Dates In reply to
You have to use the greater-than and less-than searches.



------------------
JPD
Jan 19, 1999, 8:19 AM
Alex
Administrator (9387 posts)
Jan 19, 1999, 8:19 AM
Post #3 of 5
Views: 2298
Shortcut
Quote Reply
Re: Searching on Dates In reply to
But there's no reason you should have to if you are not doing a range search. Remove:

Quote:
($db_sort{$column} eq 'date') and (&date_to_unix($in{$column}) or return "Invalid date format: '$in{$column}'");

from sub query in db.cgi, around line 340. Right after:

if ($in{$column} !~ /^\s*$/) {

That should give you the best of both worlds.

Cheers,

Alex
Jan 20, 1999, 11:45 PM
Jaime Ortega
User (119 posts)
Jan 20, 1999, 11:45 PM
Post #4 of 5
Views: 2298
Shortcut
Quote Reply
Re: Searching on Dates In reply to
Hello Alex, JPD,

I deleted the stuff that Alex said and it works fine. I can now search on dates using strings.

Thanks.

Also, you say that I will not be able to do range searches now. Can you give me an exaple of a search that would not work now?

Cheers
-JO
Jan 21, 1999, 10:42 AM
Alex
Administrator (9387 posts)
Jan 21, 1999, 10:42 AM
Post #5 of 5
Views: 2314
Shortcut
Quote Reply
Re: Searching on Dates In reply to
No, everything should work now. Range searches and all!

Cheers,

Alex