Jump to content
Sign in to follow this  

Error 500

Recommended Posts

I'm trying to make a search of a date range.

I can make of the last 2 months, the next 3, last 3, but doesn't work if i get into a month of the last year or the next one.


Month ( Get ( CurrentDate ) ) - 5 & "..." & Month ( Get ( CurrentDate ) ) WORKS, it shows the last 6 month period.

But if I want last 9 months it doesn't.

Month ( Get ( CurrentDate ) ) - 8 & "..." & Month ( Get ( CurrentDate ) )

The script shows 500 error.

This seems to work only for the current year.

Could anyone tell me what am I doing wrong or where the problem is?

Share this post

Link to post
Share on other sites

What about:

Date ( Month ( Get ( CurrentDate ) ) - 8 ; 1 ; Year ( Get ( CurrentDate ) ) )

& "..." &

Get ( CurrentDate )

Share this post

Link to post
Share on other sites

The problem is that while Filemaker will gladly translate criteria entered as "3..8" into "3/*/2012..8/*/2012" (if using m/d/y date format), it doesn't know what to do with numbers outside the 1..12 range.

Try something like Daniele's suggestion - which he posted while I was writing the above...

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.

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.