NavigationVideo Browser
|
Searching For DatesPosted by: Editor / Tuesday, May 29, 2007 – 1:58pm
When searching for dates within FileMaker 8 and higher, it’s possible to specify a limiting range of months, days or years. All you need to remember is the use of the asterisk (*) to mean any and the braces {} to group for a specific range. Here’s a great example. Search for only the fourth quarter records within the line items table. Include only sales between 1999 and 2002. Enter Find Mode and input the following into the date field.
Performing the find will return only those records meeting the range criteria. Find more information about this within the FileMaker help files. Search for keyword “finding dates” or “finding ranges”. Filed under: Reference | Calculations
. Oops. - ADMIN POSTED THIS.
. Editor said this on Wednesday, May 30, 2007 - 2:47pm.
. You're right. My mind was time shifted due to new-infant-no-sleep syndrome. ;) I'll fix it. . . Date range in calculation field.
. kokochico said this on Thursday, July 19, 2007 - 5:13am.
. Hi Matt, Is it possible to put this date range {10…12}/*/{1999…2002} in a calculation field or is this only possible in the Find mode or Set field? Would like to have this: Koko . |
Be Notified!Let us tell you when a new video is posted. We'll send you an email with a direct link right to your email inbox.
Make sure and whitelist (or add to your address book editor@filemakermagazine.comiPod Video
10 Most Recent Videos
|
re: Searching for dates
Hi Matt,
In the example, you say you are searching within the third quarter, but the month range of 10...12 in your find command would correspond to the fourth quarter assuming a fiscal year?
Doug