topic Problem with RANGE in Application Development and Automation Discussions

Problem with RANGE

miguelngel_garcsramrez — Thu, 15 Jul 2010 14:59:34 GMT

Good morning, people of the forum ...

I have the following question ...

Is there any sentence that tells me if a range is contained within another range of the same type??

Thanks

Re: Problem with RANGE

Former Member — Thu, 15 Jul 2010 15:05:50 GMT

well, if the ranges are same you can always check

if range1[] = range2[]

.. else you will have to loop over one range and read the values from the other range to compare.

Re: Problem with RANGE

Former Member — Thu, 15 Jul 2010 15:07:49 GMT

Use 'IN' keyword to validate.

Eg: Range1[] in Range2[]

Re: Problem with RANGE

miguelngel_garcsramrez — Mon, 19 Jul 2010 18:00:16 GMT

I think the second answer is more appropriate ...

But I do not think I expressed myself very well ...

What I really want is to know if there is intersection between two ranges of the same type (not necessarily equal).

For example, for two ranges of type DATE, if the first range is from 01/05/2010 to 31/05/2010 and the second range is from 05/15/2010 until 15/06/2010 (in format dd/MM/yyyy), the result should be TRUE, but if the ranges do not intersect, the result should be FALSE.

Is this possible??

Re: Problem with RANGE

kesavadas_thekkillath — Mon, 19 Jul 2010 18:10:32 GMT

Well you can try this logic

loop at r1.

while r1-low < = r1-high.

if r1-low in r2.

exists.

exit.

endif.

r1-low = r1-low + 1.

endif.

endwhile.

Re: Problem with RANGE

miguelngel_garcsramrez — Mon, 19 Jul 2010 20:06:46 GMT

You mean... evaluate each value of r1 in r2???

Yeah... I can do that, but I thought there was a simpler and more abreviated method...

Well, I think I'll take your suggest..

Thanks