Reply to this post | Go Back

View Post [edit]

Poster:	stbalbach	Date:	March 24, 2007 11:47:16pm
Forum:	texts	Subject:	Searching by date not working

I'm trying to search for all books added to IA on a certain date. I tried advanced search with a few methods and nothing seems to work:

1. Entering the date field returns 0 hits.
2. Enter a custom field on "public_date" or "publicdate" gets no hits (actually, using the "publicdate" field returns a database error).

Using the date field only seems to return results for the audio archive but none of the others.

Reply to this post

Reply [edit]

Poster:	ARossi	Date:	March 26, 2007 04:42:45pm
Forum:	texts	Subject:	Re: Searching by date not working

Hi,

For some reason, the advanced search form is putting () around the query instead of "". Try this:

publicdate:"2006-12-22*"

The * at the end of the date is a wildcard. Since the dates look like this:

2006-12-22 12:20:35

Where 12:20:35 is the time, the * let's you search for just the date regardless of what time it was posted on that date.

So if you want to see all texts published on that date, your query would be:

mediatype:texts AND publicdate:"2006-12-22*"

The AND means that both conditions must be satisfied (it has to be in all caps).

Thanks,

Alexis

Reply to this post

Reply [edit]

Poster:	stbalbach	Date:	March 26, 2007 09:32:20pm
Forum:	texts	Subject:	Re: Searching by date not working

Thanks that worked. Even without the "" or * it seems to work.