bert Posted May 4, 2002 Share Posted May 4, 2002 I have a database with a datefield. I need to find the records that have no date in the datefield (finding =) and those who contain a date after the date of today minus 8 days. So today is 04-05-2002, I need to find > 26-04-2002. It is necessary to perform this find in a script but whatever I tried it does not work. Does anyone have a solution ? Bert Link to comment Share on other sites More sharing options...
LiveOak Posted May 4, 2002 Share Posted May 4, 2002 Often asked question. First, the date field must be on the current layout. Let's say your date is in a global date field called "gDate". This script might look like: Set Field (gDate, Status(CurrentDate) - 8) Enter Find Mode() Insert Text (yourfield, ">") Insert Calculated Result (yourfield, gDate) Perform Find () Make sure the "select" option is off on the second insert or it will wipe of the first (">"). Also don't use the "Today" function, use Status(CurrentDate) instead. -bd Link to comment Share on other sites More sharing options...
bert Posted May 4, 2002 Author Share Posted May 4, 2002 Yes, this works fine, thanks a lot ! Bert Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8188 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