Using find in TimeStamps

[R2D2]

Hi !

I'm working with a student testing solution. The student gets a certain amount of questions and he has unlimited time to solve them all. When he has done them all it's time for results. But only the last 30 minutes counts. If the student have used 45 minutes to complete all the questions, only the questions answered during last 30 minutes counts.

So when the final question is answered FileMaker performs CountResult -script and a Find -function. One script step goes like this:

Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp )

It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered).

This Find never returns anything. So where is the problem ?

[grumbachr]

Hi !

I'm working with a student testing solution. The student gets a certain amount of questions and he has unlimited time to solve them all. When he has done them all it's time for results. But only the last 30 minutes counts. If the student have used 45 minutes to complete all the questions, only the questions answered during last 30 minutes counts.

So when the final question is answered FileMaker performs CountResult -script and a Find -function. One script step goes like this:

Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp )

It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered).

This Find never returns anything. So where is the problem ?

Change your "Get ( CurrentTimeStamp ) - Time ( 0;30;0 )" to something like this.

Time ( Hour ( Get ( CurrentTimeStamp ) ) ; Minute ( Get ( CurrentTimeStamp ) ) -30 ; Seconds ( Get ( CurrentTimeStamp ) ) )

[R2D2]

Still no success... Now the search string in the TimeStamp -field look like this: 20:23:17…1.3.2012 20:53:17

[comment]

Get ( CurrentTimeStamp ) - Time ( 0;30;0 ) & "…" & Get ( CurrentTimeStamp )

It is inserted in find mode to a TimeStamp field (each answer gets its own timestamp when answered).

I don't see why it wouldn't work as expected. Check that the field is indeed of Timestamp type. Also see what are the actual criteria used, by selecting Modify Last Find from the Records menu.

[R2D2]

Uuh... Yeah ! Of course ! The field was a "Text" -field. Now it works.

Thanks again !!