mhudd Posted January 31, 2002 Share Posted January 31, 2002 I have a date field and I want to create a script that returns all records that contain "today's date" and all dates prior. I appreciate your help! Michael Link to comment Share on other sites More sharing options...
Mark Appleby Posted January 31, 2002 Share Posted January 31, 2002 Find All Records then run a find in the date field type"<= //" excluding quotes then create a script called find records today and earlier then then script the find. Link to comment Share on other sites More sharing options...
mhudd Posted January 31, 2002 Author Share Posted January 31, 2002 I tried funning a find using your suggestion of <= // however, Filemaker returns "The date in this field must be a valid date in the range..." Am I doing something wrong? Link to comment Share on other sites More sharing options...
Vaughan Posted February 1, 2002 Share Posted February 1, 2002 Try scripting the process, and use <= Status(CurrentDate) Link to comment Share on other sites More sharing options...
Kremlarkin Posted January 1, 2004 Share Posted January 1, 2004 This post is WAY late given when the original question was posted. Anyway, when Mark Appleby suggested using "<= //" to find all dates equal to and before today, the reason filemaker barfed at you was the space between the "=" and the "//" terms. Just remove the space and you will end up with "<=//", which should work. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7585 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now