FIND by Expriation Date

Hello, how can we do a FIND by expiration date specifying only the "YEAR".

A FIND fails when I search by a YEAR for example: 2001 or 01, etc. Is there a way to do this? So far only entering a specific date works.

Thanks.

 

Search for 1/1/2001...12/31/2001

 

Ah no. If you used OG you would know that.

 

Actually... I think he's right Jeremy.

If you put in a date, the three periods ... and another date, it will find dates within the date ranges specified. Obviously, you would put them in the appropriate date field.

So, 01/01/2008...12/31/2008, in the "Established Date" field, will find all accounts created between the two dates.

Of course, the dates you use must be valid dates.

Of course, you're not specifying JUST the year, but, technically, you are including everything within a particular year with that search...

Obviously, you could use this for the Expiration, Termination, and Contract End date fields, as well as any other date field.

 

Unbelievable... Here I thought it was another one of these post count padders that lurk around here. Thanks guys.. It looked like "01/01/2008...12/31/2008", meaning, just put in the date range "01/01/2008" and "12/31/2008"

However, "01/01/2008...12/31/2008" in the exp field seems to do it. Thanks again!!! FM is a strange bird.