Solved

FIlemaker 5.5 - Searching by Date (ugh)

Posted on 2002-04-02
6
352 Views
Last Modified: 2010-04-27
I'm having a problem trying to perform a find on a date field.  Basically, I'm trying desparately to search a date range.  The first paramter for the date range is a field, and the second is Today (or `//`).  Everytime I try to do a scipted or manual find, is craps out trying to figure out the date field (by crap out, I mean it doesn't find anything).  This is becoming an issue as we are working mainly with date ranges throughout this whole project.  Luckily, it's just beginning, but this is problem enough to bug me.

All help would be appreciated.  If you could show me how to search by date ranges that would be great.
0
Comment
Question by:mgonyea
6 Comments
 
LVL 30

Expert Comment

by:weed
ID: 6913614
Cant reproduce the problem here. Command-F to initiate a Find. In the date field i enter the start date, select the popup that indicates range "..." and also for the todays date parameter "//". Hit the find button and it pops up the correct range. It may be a problem with your field being set to something other than Date. Or perhaps the date field wants a different format for the dates. 1/1/01 instead of 1/1/2001. Something to think about.
0
 

Expert Comment

by:smphoto
ID: 6914973
First check to see how your system is set for date formatting.
Filemaker defaults to the system setting, but prefers the following format - m/d/yyyy. If you use this format on your system for data entry, it will work better. For reports you can customize the date format to suit you.

Second, if you are trying to make this work in a script, then you have to use the script command - Insert Calculated Result - to input the date range into the date field you are searching on.
The calculation inserted should be as follows:
DateToText(1st_date_field &"..."& Today).

This inputs the date as text provided the date in the 1st_date_field is in the proper format - m/d/yyyy.

This should work. Let me know.
0
 
LVL 30

Expert Comment

by:weed
ID: 6915036
smphoto: please read the guidelines for posting comments and answers.
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

Expert Comment

by:ComTech
ID: 6915378
Hello smphoto, your commnet could still be considered, but please use the Comment vs. the Answer button, here is why:

Advice for Experts on Providing Solutions Through Comments or Answers

Experts may post solutions to your question in the form of a comment or answer, so be sure to check every email notification as soon as it arrives. Often, an Expert posts the solution to your problem as a comment because it is early in the collaboration process and other issues may be involved. In addition, it is common etiquette in some topics areas to always post comments and not answers. There are several reasons behind this thinking:

Questions do not become prematurely locked and the collaboration process is not inhibited when the question is indexed as open for proposed solutions.
The question-asker has the power to select the best solution rather than one that is simply suggested as an answer.
**Watch out for unclear or multiple-part questions. You can send a comment to the member requesting that they rephrase or break up the question before you submit an answer.
**If you don't know the answer, leave the question for someone else.
**If you are unsure of your solution, post it as a comment rather than an answer. Members can accept comments as solutions and award points for them.
**You are only responsible for providing one reasonable answer.
**You may review information about a member, including their grading history, by clicking on their member name.

Taken from the Site Rules on Answering a Question.  

Regards,
ComTech
CS Admin @ EE
0
 

Accepted Solution

by:
smphoto earned 100 total points
ID: 6915636
First check to see how your system is set for date formatting.
Filemaker defaults to the system setting, but prefers the following format - m/d/yyyy. If you use this
format on your system for date entry, it will work better. For reports you can customize the date format
to suit you.

Second, if you are trying to make this work in a script, then you have to use the script command - Insert
Calculated Result - to input the date range into the date field you are searching on.
The calculation inserted should be as follows:
DateToText(1st_date_field &"..."& Today).

This inputs the date as text provided the date in the 1st_date_field is in the proper format - m/d/yyyy.

This should work. Let me know.
0
 
LVL 1

Author Comment

by:mgonyea
ID: 6926053
Dang.  I came up with a different solution than yours, smphoto; however, your solution also worked, so I'm awarding the points anyways.

Thanks a bunch.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
FilemaKER Advanced Server 12 15 792
Filemaker Display Images 1 252
How to count the number of each duplicate record in Filemaker Pro 13 3 362
Filemaker 14 - Related tables 2 67
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question