AnsweredAssumed Answered

loop and if scripting

Question asked by CliveB on Feb 14, 2009
Latest reply on Feb 14, 2009 by comment_1


loop and if scripting


I am currently teaching myself Filemaker Pro 9, learnt a bit including some script steps so far but am stuck on a test script step.

I have 2 tables, one with a lot of data including a date field and one where the user has to enter two dates a "start date" and "end date". These two dates are to be compared in the other table so that any data less than the start date and greater than the end date will be omitted. This is eluding me completely.

I have tried an if statement within a loop, testing whether any date in Table one is less than or greater than the dates entered in Table two.

I receive no error condition when I save the script, but when applied I get all data from Table one with no omitions.

Can someone out there give me a clue as to what I should do. No wisecracks accepted.

Kind regards

Clive B