FM8 time find probs

[dkemme]

In switching from FM7 to FM8, I have encountered I believe a bug. I have a script that goes to a layout, enters find mode without pause, set a time field to a given time, and then performs a find. Worked great in FM7, but in FM8 it sets a ".*" after the time. Attached is an example. I have tried to do a left(time,8) to just use the first correct 8 characters but will not correct. Any suggestions?

timeprobs.zip

[comment]

It's a feature, not a bug. The entry "11:00:00.*" means find records where time field has the hour 11, minute 0, second 0 and ANY fractional second.

In version 8, you can use the widcard character * in date and time fields - see Help > Finding, sorting, and replacing data > Finding records > Finding numbers, dates, times, and timestamps.

Seems that if you do not explicitly specify a fractional second, FMP 8 will automatically place a wildcard in that position.

[dkemme]

Interesting that the get ( currenttime ) also places the same wildcard. I will try adding fractional seconds to see if "bug/feature" disappears.

THANKS