time

[dmalone]

How do you omit files with an entry in a time field.

[Lee Smith]

You need to add a second find criteria by adding a second find request.

New Record Request

Then put an = (equal sign) in the Time field

This will find only records with no entry in the time field

HTH

Lee

[Lee Smith]

I should have added that if you are trying to do this via a Script, do the find first manually, get it the way you want it, and then create your script. FileMaker remembers the last find automatically and use that in new scripts.

HTH

Lee

[Steve K]

More information please

[Lee Smith]

Hi Steve,

Please explain what you asking for here?

Lee

[dmalone]

This is a complicated script that finds records within ranges of several fields, with alternate actions depending on values. After this i need to omit all records with a time in the time field.

I cannot do it manually.

Isn't there a way to write it in a script .

[Lee Smith]

Just do the omit manually the first time, and then create a script step called "omit time", and than add step where needed in your other script.

HTH

Lee

P.S.

In the future, don't be so criptic in your requests. The more information you supply up front, the better the help you will receive and the more time that will be saved all around.

[dmalone]

Manually, I wrote a find ommitting all fields with an entry in the time field. This took two requests - one to omit all records before a time and another to omit all records after the same time. But when I add a call to this script at the end of the larger script, I don't get the the first criteria of the larger script. I get ALL the records with empty time fields as if the other part of the script did not exist. How can I make this time field criterion just a further deliniation. Sorry if I am dense or criptic.

[-Queue-]

You must combine these requests with your other find criteria. If you perform two separate finds, the result is two found groups of records that are unrelated.

[Lee Smith]

Are you looking for a range of times? Such as find records between 8:00 am and 5:00 pm. Or are you looking for all record that do *NOT* have a time in a time field in them? Such as find all "Contacts" between 8/1/03 and 8/16/03 that has no Time in time field?

Lee

[McCormick]

If you want to omit ALL records that have ANY entry in the Time field, then use the equal sign. Put an equal sign into the Time field on every Request in that find. The equal sign means "and this must be empty", so if you are searching for, say, LastName = "Jones" OR "Smith", you will sue two reqeusts an they must both have "=" in the time field.

To put this step in a script, you could include a Loop that uses Set Field in every request. If it is the same find every time, then do it manually and "record" it into a script.

If you are trying to eliminate a certain time or a certain range of times, then you have to enter the full time down to the seconds. If you cut it short, it will assume you mean zero. You also have to use military time, I believe. So if you type "10" it will be understood as "10:00:00 am", and if you type "18:30" it will be "06:30:00 pm". To serach a range, use the ellipse (...) the same as for searching dates.

"10...16" will find everything between 10:00:00 am and 4:00:00 pm. IF you toggle Omit, it will find everything else.

It might be worth your time to add a new calc field that pulls out the hour only or the hour-plus-minutes of the true time, so you can search in more intuitive way.

[dmalone]

I want all records that satisfy the limitations of the script that do *NOT* have a time in the time field. I am looking for records within a range of values in a couple of other fields, including alternate actions for over ranging and alternate actions depending on a mode field. After all of this delimits the find (which is working fine) I want to exclude the set further by omitting the ones that have an entry in the time field. I also tried to write a "=" in the requests but FMP reads this as 0:00:00 instead of an empty field.

[McCormick]

Hm. I'm a bit baffled that the equal sign isn't working for you. If I do a Find with the only criteria being an equal sign in the time field, it gives me back everything with an empty time field. You're not including the quotation marks, are you?

If the = sign will work for you, then the answer is to merely include it on every Request of your search. If it's not doing what it's supposed to, I'm stumped. What version of FMP are you using?

If you want to extract this step and do it after other searching, then build a script like this:

Modify Last Find

Go to Request (First)

Loop

Set Field (Time, "=")

Go to Request (Next) [exit after last]

End Loop

Perform Find

Which will just insert = signs into all of your existing fields.

Of course, you don't want to include them on Omitted requests...

[Lee Smith]

Try this as your Find for blank Times

Enter Find Mode []

Insert Calculated Result [select,