Spot on, Gunnar Regards, Alastair. From: Gunnar Ekblad Sent: Thursday, November 05, 2009 6:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search
Bill I suggest' the following enhancement request EXPORT memory from BILL to the LIST It does not have come with 7.6 or 8.0 I believe 9.9 is enough. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Bill Downall Skickat: den 5 november 2009 19:10 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Birthday Search Dennis, That was in our David M. Blocker R:BASE training courses in 1986. Bill On Thu, Nov 5, 2009 at 1:00 PM, Dennis McGrath <[email protected]> wrote: Well Bill, I've been around a looooong time and I never knew that would work. First time in all 24 years with RBASE that I have seen that syntax for dates. Go figure! Dennis McGrath ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, November 05, 2009 11:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search Is that a "duh!" moment for a few people? That capability has been around since R:BASE 2.11 or earlier. It's cold in Pittsburgh in the winter. Send coat money to Project Bundle-Up, c/o Donna Memon, R:BASE Technologies, 3935 Old William Penn Highway Murrysville, PA, 15668-1854 USA Bill On Thu, Nov 5, 2009 at 12:34 PM, George H Baker Charter <[email protected]> wrote: My Thanks also. Bill, I include several date ranges in searches. Never knew that this was possible and it is very usable for my purposes. George ----- Original Message ----- From: Alastair Burr To: RBASE-L Mailing List Sent: Thursday, November 05, 2009 11:23 AM Subject: [RBASE-L] - Re: Birthday Search All these years and I never knew that you could do that with dates! Thanks, Bill, Regards, Alastair. From: Bill Downall Sent: Thursday, November 05, 2009 5:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Birthday Search Jennifer, Just use the wild card character! It won't use indexes, so if you have a million rows to search through, your 3-column strategy might pay off, but otherwise, just teach them to search like this: This presumes you use the default SQL wildcard character of %. If you use *, then replace the % with *. (To see what your current 'MANY' character is, at the R> prompt, type SHOW CHAR) 12/%/1990 -- anything in december, 1990 %/15/2009 -- anything on the 15th of any month in 2009 11/05/% -- anything on November 5, no matter what year Bill On Thu, Nov 5, 2009 at 12:04 PM, Roberts, Jennifer <[email protected]> wrote: Hello, I seem to have quite a bit of 'brain fog' this morning and I am unable to figure out a good way to let my users search for their clients that have a birthday within selected dates. I am thinking that I should create a temp table of their clients and add a two columns, one to hold the integer month (IMON) and the other to hold the integer day (IDAY). Would this be the most efficient way or is there a function in RBASE that would allow me to search just the month and year of a date? Thank you in advance, Jennifer Roberts Business Applications Specialist Ohio Masonic Home This electronic message contains information from the Ohio Masonic Home,its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are notthe designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediatelyat [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwiseunlawful or inappropriate is strictly prohibited by The Ohio Masonic Home. -------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.698 / Virus Database: 270.14.50/2481 - Release Date: 11/04/09 19:51:00 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.698 / Virus Database: 270.14.50/2481 - Release Date: 11/04/09 19:51:00
