topic Coincidence between two range dates in Application Development and Automation Discussions

Coincidence between two range dates

Former Member — Mon, 14 Apr 2008 09:26:49 GMT

Hello.

Is there any FM return the days that coincidence two ranges of dates?

Example:

Date1 ='20080101 'to'20080115'.

Date2 ='20080110 'to'20080120'.

The result would be: 5 days.

Thanks.

Former Member — Mon, 14 Apr 2008 09:44:23 GMT

u can do it like this way:

result = ( Day2 - Day1 ).

= { ( 20080115 - 20080101 ) - ( 20080120 - 20080110 ) } .

As the date is sydatum format u can substraction between two dates.

Former Member — Mon, 14 Apr 2008 09:49:22 GMT

Hi,

take


days = date1-high - date2-low.

rgds,

bharat.

Former Member — Mon, 14 Apr 2008 10:04:46 GMT

Hi,

DO the following modification:

For eg.

dates: 20080101 -- 20080103.

and 20080102 -- 20080104.

take one internal table

and append records as follows.

itab:

20080101

20080102

20080103

20080102

20080103

20080104

Use describe lines to find no of records.

Here 6 i our case.

sort it and apply delete adjacent duplicates.

check no of record using describe lines.

Here it wud be 4.

Difference will give you the common days.

6-4 = 2.

Regards,

Nishant