Someone earlier on this board kindly helped me with a script to find the current month.

http://www.fmforums.com/forum/showtopic.php?tid/186398/

Now, I would also like to make a script to find both the current month and next month and display the results together. I assume that it can be accomplished by modifying the previous script, but I'm such a rank beginner that I'm not sure what changes to make. Thanks for the help in advance.

Since you're on the latest version should you exploit the newest featurea for searching ranges with *'s

http://www.filemaker.com/help/03-Finding%20sorting6.html

--sd

Yes, but to script such find is often no less complex than calculating the actual start/end dates - especially if you don't want to depend on the file/OS date format.

This is the script that I'm using to find the current month. How can I alter it to find the current month plus next month?

Let( monthOffset = Get(ScriptParameter) ;

Date ( Month(Get(CurrentDate)) + monthOffset; 1 ; Year(Get(CurrentDate)) ) & "..." & Date( Month(Get(CurrentDate)) + 1 + monthOffset ; 0 ; Year(Get(CurrentDate))) )

Make another button that calls the same script. In the button definition, enter 1 as the script parameter. To find records of the previous month, make the script parameter = -1, and so on.

Thanks for the reply. Yes, I understand about how to set up the Script Parameter to find this month, last month, next month, etc. But, how do I set it up to find records for BOTH this month and next month at the same time?

I appreciate your help.

Current month plus next month?

Let( [monthOffset = Get(ScriptParameter) ;

currentYear = Year(Get(CurrentDate));

currentMonth = Month(Get(CurrentDate)) + monthOffset ];

"{" & currentMonth & "..." & currentMonth+1 "}"

& currentYear )

This will produce something like:

{5...6}/2007

which assumes you're using M/D/Y, and uses the new (FM8 only) date search ranges.

Edited May 4, 200718 yr by Guest
Forgot about monthOffset.

Hi Nishimark,

I've always had issues with date formats in FM so I don't really take advantage of the new search types at least not in scripts.. but the method Shawn suggests will work perfectly... Otherwise:

Let( monthOffset = Get(ScriptParameter) ;

Date ( Month(Get(CurrentDate)) + monthOffset; 1 ; Year(Get(CurrentDate)) ) & "..." & Date( Month(Get(CurrentDate)) + 2 + monthOffset ; 0 ; Year(Get(CurrentDate))) )

Great! The script from Genex works perfectly. Thanks again for the help.