Date find script not working...

[wildasIwanabe]

Hi,

I'm using Filemaker 5.5 and I'm trying to write a script that finds records in the past 7 days.

This is what I've done:

[color:blue]Enter Mode Find[]

[color:blue]Set Field[Date, Today-7 & "..." & Today]

But this does not seem to work correctly. The only thing that gets entered into the date field is the value for 'Today-6'. The rest of the code some how just gets ignored.

Does anyone have any ideas how I can get this to work?

[mr_vodka]

Please take a look at this post

[mr_vodka]

P.S. One more thing...

Just a word of advice, I would stay away from the 'Today' function as it was buggy and no longer supported post version 6.

[wildasIwanabe]

HOLY COW! IT WORKED..

Thanks a lot mate. I would have never got that one.