November 9, 200619 yr 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?
November 9, 200619 yr 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.
November 9, 200619 yr Author HOLY COW! IT WORKED.. Thanks a lot mate. I would have never got that one.
Create an account or sign in to comment