Jump to content

Find birthdays


DanBrill
 Share

This topic is 6793 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there any way the end user can find all of the birthdays for a month? Something like, 'find all of the people with March birthdays.' By 'end user', I mean can this be done without acalc fields that parses out a birthdate's month and then finds on that calc field? Is it just possible to search a date field for somehthing like 03/**/****, or do I have to break down and do this the old fashioned way?

Dan

Link to comment
Share on other sites

Hi Underhat,

Thanks for your response. Your search would result in all of the March 2003 birthdays. I want to find all the March birthdays of any year. I was hoping to find a way to do it right from the Date Of Birth (DOB) field to avoid cluttering up an already-crowded layout.

But I can't seem to find a way, so I just created a calc_BirthMonth=MonthName(DOB). The user can enter the birth month (selected from a drop-down custom value list of the names of the months) and search on that. This will find all of the March babies from infants to centenarians. Works fine, just isn't quite as elegant as I'd hoped.

Thanks,

Dan

Link to comment
Share on other sites

Dan said...Works fine, just isn't quite as elegant as I'd hoped.

Hi Dan, smile.gif Maybe it's not quite as elegant to you but it's soooo much easier for your Users than trying to remember to type something like 03/**/**** (or any other combination of strange symbols that they don't understand) and it will produce consistent results. Every time you open things up for inconsistent data-entry, finds, etc, you also increase the possibility of errors or finding incorrect data. Most Users don't remember these keystrokes and, if a User has to stop working to figure out the correct symbol combinations or worse, enters the wrong information (and thus finds an incorrect set on which to perform their work) - like mass mailing to the wrong set - then the method is no longer elegant. crazy.gif

To save layout space, you can place that calc (with Allow Entry off) under your standard birthday field (with background on birthday field opaque). Users won't know it's there unless you pop it with your find script. It will look like they're searching the BirthDate field. wink.gif Something like:

Go to Field [ BirthdayCalc ]

Enter Find Mode []

Pause/Resume Script [ "0:00:01" ]

Perform Find [ Replace Found Set ]

All you need is a button next to it or activate it from Script Menu dropdown or script shorcut key. And your Value List could be from field values based upon this calculation (MonthName(Birthdate) if you had Index ON for the calc. In this way, you wouldn't need to script for No Records Found because the VL wouldn't display a month if no one had a birthdate in that month. Of course using values from field would produce the list is strict alpha order. Some Users like it alpha, some like it in calendar sequence as I'm sure you've added it in Custom. I think your decision was perfect. smile.gif

LaRetta

Link to comment
Share on other sites

This topic is 6793 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.