Searching on a time field

[John.M]

What's the trick to finding time in filemaker? I have the following going into the field: >17:37:04.* Filemaker keeps adding the ".*' at the end. If I manually do the search and enter >17:37, it works. I've tried GetAsText, GetAsTime, Filter, Left; but the format changes and adds the ".*" after the set field step. Is there a way to not have that happen in a time field?

Thanks,

John

[comment]

What exactly is your question? Filemaker adds ".*" to your criterion, because you haven't specified any fractional part of seconds. In practical terms, your request is translated into "≥17:37:05.0". Which should be good enough, unless you have records with time 17:37:04.5 and you want them included in the found set.

If I manually do the search and enter >17:37, it works

It works exactly the same way: ">17:37" is transformed into ">17:37:*".

[John.M]

I'm picking up a time value in one table, storing it in a global, going to it's related records and performing a find in the child table on records greater than a certain time after the time in the global.

For example, the parent record time = 15:17, the set field is ">" & (gtime + 1200).

The perform find via the script fails but when I do it manually it works.

What is the difference with what's in the calc versus the manual find?

Thanks,

John

[comment]

I suggest you make a pause just before performing the find, and examine the request. If your global field contains "15:17", your searched field should at this point be showing ">15:37:00.*" - which, as I said, will find any records with time equal to or greater than 15:37:01.