Vivian Posted September 11, 2006 Share Posted September 11, 2006 I need to write a script to find all records where the Month of the "Due Date" field is equal to the Month of the current date. HELP, please I'm a new user of FileMaker Thanks! Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 11, 2006 Share Posted September 11, 2006 In the box in the middle of this page: http://www.databasepros.com/resources.html Type in the following "Date Search Techniques" and switch the radiobutton to 8 and press the button called find! --sd Link to comment Share on other sites More sharing options...
Vivian Posted September 11, 2006 Author Share Posted September 11, 2006 Thanks, but that was a bust Link to comment Share on other sites More sharing options...
LaRetta Posted September 11, 2006 Share Posted September 11, 2006 Hi Vivian, That type of response makes it very difficult for us to know what didn't work for you. A bit more information would be helpful here. : LaRetta Link to comment Share on other sites More sharing options...
Vivian Posted September 11, 2006 Author Share Posted September 11, 2006 Sorry, didn't mean to offend anyone, I just meant that there were no results for my search. I tried several different searches, rewording every time. I did figure it out anyway. If Month(Due Date) = Month(Get(CurrentDate)) Thanks for your help. Link to comment Share on other sites More sharing options...
LaRetta Posted September 11, 2006 Share Posted September 11, 2006 (edited) I just tried Soren's exact directions and it works perfectly. I wasn't offended but I can't speak for Soren. I have no idea how yours works - unless you created a calculation (number) as boolean and search for the 1. But it can be easier than that WITHOUT the extra calculation: Enter Find Mode [ ] ... uncheck pause Set Field [ yourDateField ; Month ( Get ( CurrentDate ) ) & "/*/*" ] Perform Find [ ] Also searching FM Help 'Finding numbers, dates, times, and timestamps' will give you other new search options using wildcards and range spans. Very cool stuff. Edited September 11, 2006 by Guest Added sentence Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6564 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