Jump to content
Sign in to follow this  
Nishimark

How do I find "current month" and "next month"?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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))) )

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by Guest
Forgot about monthOffset.

Share this post


Link to post
Share on other sites

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))) )

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.