Jump to content

why is my date find script not constraining correctly?


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

Recommended Posts

Hi All,

 

I have written a date search script to perform a search on a field called submittedDate. (this is a date field in a table called claim). I have a layout based on a table called person. Person is linked to Claim, claim.id = person.claimId.

 

I have also created an unrelated table with globalstartdate and globalenddate fields. I have created a layout based on this unrelated table and put two date pickers on that view and a button. The button runs a script that does the following:

 

Go to Layout ["MyClaimLayout"]

Enter Find Mode[]

Set Field [claim::submittedDate; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate]

Set Field [claim::commital;0]

Perform Find[]

 

I run this and the between dates just isn't filtering. I have chosen 12/01/2015 to 13/01/2015 as my date range and a row from 01/01/2015 appears  :hmm: .

 

Have i done something wrong here?

 

Many thanks

Link to post
Share on other sites
Go to Layout ["MyClaimLayout"]

Enter Find Mode[]

Set Field [claim::submittedDate; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate]

Set Field [claim::commital;0]

Perform Find[]

 

That looks like it should work. Possible causes of failure:

  • "MyClaimLayout" is not a layout of the "claim" TO;
  • The searched field ("claim::submittedDate") is not a Date field;
  • The searched field contains invalid dates (search for ? to find these);
  • The searched field needs to be re-indexed.
Link to post
Share on other sites

This topic is 2030 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

×
×
  • Create New...

Important Information

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