Finding records in a specific month

[guyzo]

Hi. Can someone provide some assistance please.

So , heres what I am trying to do.

I have several fields that contain different dates. I want to be able to find all records where that date occur for example in Jan. The year is not required part of the search.

So, I have the fields: Item 1 Exprey date 01/25/2012

Item 2 Expirey date 05/31/2001

Item 3 Expirey date 01/17/1967

The script or find should ask "What month do you want to find?" User should then be able to enter a month or a range of months, eg. Jan, Feb or whatever.

The scipt should then return "Exprey dates occuring in Jan (or whatever month) and then show records that have Item 1 and 3 expirey dates. (Jan expireies!) but, would of course exclude item 2 as it occures in May.

Or I may need to find all items for the months of Jan, Feb and Mar.

Thanks so much in advance.

[bcooney]

Have fields named Item 1 Expirey Date, Item 2 Expirey Date, etc. is an indication of a possibly poorly structured data model. Each item should be a record related to a parent. As you'll see, not having the proper structure comes back to haunt you when you try to report.

That being said, finding across multiple fields, an OR search, is accomplished using New Request in Find Mode. Finding for a month is done by entering 1/*/* which'll find all January dates, regardless of day or year.

hth,

Barbara

[comment]

You can also find a range of months - for example searching for {1..3}/*/* will find all dates in January, February or March of any year (if you are using m/d/y as your date format).

Perhaps you should have your users enter the months they want into a global field formatted as a checkbox - then have your script translate their entry into a search criteria as shown above.