Hi-
I am in need of finding a group of people with birthdates between certain
calendar dates. All of the birthdates are located in a specific date field.
Can anyone explain to me how to go about performing a search to find only
those dates that fall within my parameters?
Thanks!
Chris
As described in Help:
Start date, two or three dots, end date
( 1/1/2007...6/6/2007 )
Matt
On 09/20/07 11:15 AM, Chris wrote:
> Hi-
>
> I am in need of finding a group of people with birthdates between certain
> calendar dates. All of the birthdates are located in a specific date field.
> Can anyone explain to me how to go about performing a search to find only
> those dates that fall within my parameters?
>
> Thanks!
>
> Chris
>
Oh, Yeah, Help files...
Now why didn't I think of that! Doh!!
Thanks, Matt!
On 9/20/07 11:41 AM, in article jwwIi.4957$6o2.3849@trnddc05, "Matt Wills"
> As described in Help:
>
> Start date, two or three dots, end date
>
> ( 1/1/2007...6/6/2007 )
>
> Matt
>
> On 09/20/07 11:15 AM, Chris wrote:
>
>> Hi-
>>
>> I am in need of finding a group of people with birthdates between certain
>> calendar dates. All of the birthdates are located in a specific date field.
>> Can anyone explain to me how to go about performing a search to find only
>> those dates that fall within my parameters?
>>
>> Thanks!
>>
>> Chris
>>
Possibly for the same reason that I often can't find what I'm looking for?
When I can't find something in Help, it's usually because I'm calling it
something other than what the people who wrote the Help call it.
In this case, it's "Finding Ranges of Information."
Matt
On 09/20/07 11:44 AM, Chris wrote:
> Oh, Yeah, Help files...
>
> Now why didn't I think of that! Doh!!
>
> Thanks, Matt!
>
>
> On 9/20/07 11:41 AM, in article jwwIi.4957$6o2.3849@trnddc05, "Matt Wills"
>
>
>> As described in Help:
>>
>> Start date, two or three dots, end date
>>
>> ( 1/1/2007...6/6/2007 )
>>
>> Matt
>>
>> On 09/20/07 11:15 AM, Chris wrote:
>>
>>> Hi-
>>>
>>> I am in need of finding a group of people with birthdates between certain
>>> calendar dates. All of the birthdates are located in a specific date field.
>>> Can anyone explain to me how to go about performing a search to find only
>>> those dates that fall within my parameters?
>>>
>>> Thanks!
>>>
>>> Chris
>>>
>
On Sep 20, 8:15 am, Chris
> Hi-
>
> I am in need of finding a group of people with birthdates between certain
> calendar dates. All of the birthdates are located in a specific date field.
> Can anyone explain to me how to go about performing a search to find only
> those dates that fall within my parameters?
>
> Thanks!
>
> Chris
Find Mode
-- in the date field type the dates as start...end
01/01/07...02/28/07
Find
----------------
I usually script this using 2 fields for date entry as drop down
calendars
StartDate type=Date storage=Global
EndDate type=Date storage=Global
Then create a script that sets your date field:
Enter Find Mode []
Set Field [YourTable::BirthdayField ; YourTable::StartDate & "..." &
YourTable::EndDate]
Perform Find []
Set a button to run this script -
Find Date Range or Find DOB Range, whatever name you want.
Happy Searching!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
....amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 32 & 64Bit / FMP Adv 9.0v1
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The only reason some people get lost in thought
is because it's unfamiliar territory for them.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Chris wrote:
> I am in need of finding a group of people with birthdates between certain
> calendar dates. All of the birthdates are located in a specific date field.
> Can anyone explain to me how to go about performing a search to find only
> those dates that fall within my parameters?
You already got some valid answers, but none of them answers what to do
if you have actual birthdates, with a variety of years, and you want to
find everyone who has birthdays in September.
Since FM8 (?), you can search for either:
9/1/*...9/30/*
or for just 9/*/*
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles
FileMaker 8 Certified Developer
Member, FileMaker Business Alliance