why is my date find script not constraining correctly?

[bruceiow]

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  .

 

Have i done something wrong here?

 

Many thanks

[Wim Decorte]

your globals are date fields?

[bruceiow]

Indeed, both are set as "date"

[Steve Martino]

Is this a typo?  "...I have chosen 12/01/2015 to 13/01/2015...." or is this day/month/year format?

[bruceiow]

no - My date range was from 12th Jan 15 to 13th Jan 15

[Wim Decorte]

and your system is set to "m/d/y"?  Check to see what format is being enforced in the File Options.

[comment]

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.