Jump to content
Sign in to follow this  
Enigma20xx

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.

Example:

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

As always, great help and good knowledge in this forum.

Thank you very much for your help to you both, it works.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    FMDuck  jools 
×

Important Information

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