Skip to Content
0

Resolve Range Table Content

Oct 20, 2016 at 08:25 PM

53

avatar image
Former Member

Hello all,

I would like to resolve the content of range table.

The range table will be taken over from the SELECTION-SCREEN by Date from-to. The user can enter DATE from, date to, with exclusions, greater than, etc.

Now I need a function to resolve the entered ranges, that a serial date range is resulted; for example:

SIGN   = I
OPTION = BT
LOW    = 10.01.2016
HIGH   = 12.01.2016

The result is: 10.01.2016, 11.01.2016, 12.01.2016.

However, all combinations are possible, so that the result could be more complex.

Is there any function to handle this problem?

Thank you very much & best regards,

Kurt

10 |10000 characters needed characters left characters exceeded

could you tell the real scenario where you need this? Usually, we only need it while using SELECT ... WHERE datum IN date_range...

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 20, 2016 at 09:06 PM
0

Hi

So you need to get all dates meet your range?

I don't believe there's a function and it's not easy to create an algorithm, because you can have an infinte result if the range is not filled under particular conditions.

Share
10 |10000 characters needed characters left characters exceeded
Volker Binder Nov 02, 2016 at 03:46 PM
0

create a table with only one field DATE

fill it by report with all dates from 19000101 to 99991231

select all dates WHERE date IN range

Share
10 |10000 characters needed characters left characters exceeded