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!

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

Thanks, but that was a bust

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

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.

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, 200619 yr by Guest
Added sentence