Find Records for current month

[Vivian]

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!

[Søren Dyhr]

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

[Vivian]

Thanks, but that was a bust

[LaRetta]

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

[Vivian]

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.

[LaRetta]

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