topic Comparing date ranges. in Application Development and Automation Discussions

Comparing date ranges.

Former Member — Thu, 16 Jun 2011 02:10:06 GMT

Hi ,

Need your guys advice how to compare two date ranges,

As my code snippet show below, those date can not be compare even Date1 is within the range of Date2 logically...

Any guide and insight i appreciate it alot.

Thanks

.
RANGES : date1 FOR p0001-begda,
         date2 FOR p0001-endda.

date1-sign = 'I'.
date1-option = 'BT'.
date1-low = '20110101'.
date1-high = '20110808'.
APPEND date1.

date2-sign = 'I'.
date2-option = 'BT'.
date2-low = '20110101'.
date2-high = '20110808'.
APPEND date2.

IF date1 IN date2 .

  WRITE:/ 'with in date range'.
  SKIP 2.
ENDIF.

Re: Comparing date ranges.

Former Member — Thu, 16 Jun 2011 04:04:10 GMT

Hi,

Change the code like this..


if date1-low GE  date2-low and date1-low LE date2-high.
WRITE:/ 'with in date range'.
  SKIP 2.
else.
write: / 'not in the range'.
endif.

Regards,

Dhina..

Re: Comparing date ranges.

Former Member — Thu, 16 Jun 2011 04:25:43 GMT

Please find below FM.

U can give begindate and enddate then u get the differences.

HR_99S_INTERVAL_BETWEEN_DATES

Thanks$ Regards.

MURALII

Re: Comparing date ranges.

Former Member — Thu, 16 Jun 2011 04:46:05 GMT

Hi,

I think only single values can be compared with ranges and not the entire range.

Instead loop at the first range and check if the dates lies in between the other range.

loop at date1.

if date1-low in date2 and date1-high in date2.

*your coding.

else.

*coding

endif.

endloop.

Regards,

Srini.

Re: Comparing date ranges.

koolspy_ultimate — Thu, 16 Jun 2011 04:53:38 GMT

try the following


RANGES : date1 FOR p0001-begda,
         date2 FOR p0001-endda.
 
date1-sign = 'I'.
date1-option = 'BT'.
date1-low = '20110101'.
date1-high = '20110808'.
APPEND date1.
 
date2-sign = 'I'.
date2-option = 'BT'.
date2-low = '20110101'.
date2-high = '20110808'.
APPEND date2.

use any one


if date1-low GE  date2-low and date1-high LE date2-high.
or
if date1-low in date2-low and date1-high in date2-high.


 WRITE:/ 'with in date range'.
else.
write: / 'out of date range'.
ENDIF.

use this fm to calculate the date range HR_99S_INTERVAL_BETWEEN_DATES

here if the result is greater that the actual range then write: out of date range

else if the result is less than or equal to actual range then write: with in range.

NOTE: for this second method actual range refers to the difference of dates calculated by you manually.

So i suggest try the first code.

hope it solves your purpose.

thanks and regards,

koolspy.

Re: Comparing date ranges.

Former Member — Thu, 16 Jun 2011 05:13:42 GMT

For comparing single date:

if date1-LOW GE date2-low AND date1-LOW LE date2-high.

...............

endif.

for comparing range of dates.

if date1-LOW GE date2-low AND date1-HIGH LE date2-high.

...........

endif.