### Title

Search within day ranges.

### Post

I have a text field with ranges of numerical dates with carriage returns. For example:

734358 ... 734366

734365 ... 734368

734371 ... 734387

734392 ... 734396

734403 ... 734406

I can't use any relationships or create another field, by restriction. But I must find if another numerical date is among the above ranges. Lets say 734360 for example which is within the first range.

Is there any way to do this? May be by using patterncount somehow...

Thanks in advance.

Kostas.

Ideally, as discussed, those range strings should be From and To dates in a related table where every line is a record.

The problem with searching for a number within a text range such as 734358 ... 734366 is that the number does not exist within the field (and that is why records are best). But you CAN use recursion to check the spans on each line to see if the number is within the range (see link). You will need to use a global field to accept user request. You need Advanced to create a custom function in your file.

For more flexability, I created the function to count the number of times this exact number exists within each line. But you will still need to search this calculation for >0 after entering your number.

http://directlinesolutions.com/solutions/CountInRange.zip

LaRetta