AnsweredAssumed Answered

Search within day ranges.

Question asked by theta on Sep 20, 2011
Latest reply on Sep 20, 2011 by LaRetta_1

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.

Outcomes