Not sure what your after here. Are you looking for dates before the year 2014? I
n that case your find would be "<1/1/2014". if not, more information may be needed.
first ... last (dots; 2 of them are ok - FileMaker will automatically replace '..' to '...')
Dates (please note: I got dd.mm.yyyy as date-format):
6.2014 -> searches all of june, 2014
2014 -> searches all of the year 2014
1.3.2014...15.5.2014 -> searches between
1.5.2014... -> searches all after 1.5.2014
... 1.5.2014 -> searches all before
Open Manage | Database | Fields, find your fields that store dates and make sure that they are of type date and not text.
Instead of modifying your original post, please use the misnamed "Post a new Answer" to post follow up replies. It's easy to miss new info added to the original post.
I suggest describing the design of your database in more detail. You mentioned relationships. This might be an issue. If you are on a layout based on Table A and you specify search criteria in a field from a related Table B, the results you get might not be what you expected.
The design of my database is three tables consisting of Employee data, training scores and equipment. The current layout is a tabbed layout, tab 1 is employee data, tab 2 is training scores and tab 3 is equipment. When I attempt the search that I want, which is simply to get the records of all employees that have not yet completed training between the dates of 1/1/2014 through 6/2/2014. In tab 1 I have a field designated as active or resigned and I select active so only active employees are included in the search I then go to tab 2 (training scores) and attempt the suggestions in this post to search the range of dates 01/01/2014...06/02/2014 but the data returned is not correct. This database also has a unique id number assigned to each employee I have named a SID (special id) and the only relationship I have created was a one to one relationship for the SID for each employee which is in all three tables. Any suggestions?
The current layout is a tabbed layout, tab 1 is employee data, tab 2 is training scores and tab 3 is equipment.
Am I correct that this layout is based on your Employee table? (if not sure, check Show Records From in Layout Setup...)
tab 2 is training scores
And are these training scores recorded in a portal to a related table?
If so, exactly what data do you enter into the rows of that portal to document an employee's training?
Yes, I checked as instructed and tab 1 is based on the employees table and tab 2 is the training table where the employee SID, training date, training type, score and pass/fail is recorded in colums with the same names. The employee SID has a one to one relationship for all 3 tables
The tabs are not based on any tables. The LAYOUT is based on exactly one table. I would guess that this is the employees table.
Then on Tab 2, I would guess that you have a portal to a related table of records where each record records:
training date, training type, score and pass/fail
With one row of the portal used for each such entry.
But if you use a set of separate fields one set of fields to record each set of this training information--so that all of an employee's training info is recorded in a single record, then it may look like a portal but it will not work for your find.
I will assume for now that you do indeed have a portal to a related table here.
Reviewing your description of what you want to find:
I have a field designated as active or resigned and I select active so only active employees are included in the search I then go to tab 2 (training scores) and attempt the suggestions in this post to search the range of dates 01/01/2014...06/02/2014
it would appear that you select "active" in a field from the employees table tab 1, then enter a date range into the date field in the portal on tab 2. Then it would seem that you need to specify the value that indicates that they passed the training and then you'd select the "omit" option from the status area.
Is that exactly what you did?
That should work to list all employees that did not pass training in the specified date range, but it will include all non active employees. Is it possible that the inclusion of non-active employees are what is keeping this from working for you?
If so, you can return to Find mode, specify "Active" and then select "Constrain Found Set" to remove the non-active employees.
Thank you, utilizing the Constrain found set worked and gave me the records I needed. I do appreciate all the help you and the others have given thanks again.