Jump to content

scripting a date range


This topic is 7182 days old. Please don't post here. Open a new topic instead.

Recommended Posts

thanks for your response.

I tried that already but always get an empty result when there should be a result. When pausing the script to see what's happening, the date field entries go in as an FMP date format and does not retain the 1/2/2002 format Does that make a difference?

Link to comment
Share on other sites

Where is the information coming from? The number you are seeing are how FileMaker stores dates internally. Dates are simply the number of days since 1/1/0001. It sounds like the date is getting converted to a number somewhere along the line.

Without knowing how you're getting the information that you're building the search on it's difficult to offer a suggestion. Perhaps you're having the user fill in some global date fields and then using a script to build the date range string. If this is the case, try changing the global date fields to global text fields. You'll need to do some error checking to make sure the dates are valid.

If this isn't the case, then try the following:

Insert Calculated Result [ DateToText( Date1 ) & "..." & DateToText( Date2 ) ]

Chuck

Link to comment
Share on other sites

This topic is 7182 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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