Find not working properly

[gumoore]

Using FMPro 11 on server

 

Two issues.

 

Issue 1

 

Field set up as text. Format of data entered is 201/2013 - first number is sequential, second number represents year. Numbering restarts every calendar year.

 

When searching for a range between 140/2013 and 150/2013 [140/2013...150/2013], the results are as if [140*...150*] - so I'm getting all years rather than just 2013.

 

Issue 2

 

Second field. Set up as date format with drop down calendar.

 

Searching for a specific date, e.g. 12/12/2013. Returns all dates as if 12 * 2013 (that's month/day/year).

 

___________

 

I've tried checking all settings/parameters but can't figure out why I'm unable to get effective searches.f

 

Any help would be appreciated.

 

 

[comment]

The first issue is the result of inadequate data structure (more than one fact per field). Since the content is text, the range is calculated using alphabetical.order. Note that in Filemaker "201/2013" is a single word. The best way to resolve this would be to split the data into two number fields and search for 140 ..150 in one, 2013 in the other.

 

Re the second issue: can you reproduce the problem in a new file? If yes, please post it here.